-
Title
Full back up could not write to UNC path when LiteSpeed option is selected -
Description
Whenever 'use litespeed' option box is selected to run a backup ( either a mainteneance plan or just a single DB backup) , LiteSpeed prompts an error ' Could not read the drive '\\hostname01\SQL2008MTKTest\': Ensure that target file exists and is available.'.
Native SQL backups work to the folder fine.
-
Cause
Environment specific
-
Resolution
Go to the registry key SectorSizeOverride option and set it to 512HKEY_LOCAL_MACHINE\SOFTWARE\Imceda\SQLLiteSpeed\Engine\SectorSizeOverride(REG_DWORD) and set to 512.
Windows Registry Disclaimer: Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 "Description of the Microsoft Windows registry" at Microsoft Support.