How to change the default location of the backup folder?
How to change the backup folder automatically selected by LiteSpeed for the backup files?
SQL Server puts backups in a default folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Is there a way to change that to a different location?
LiteSpeed uses the default SQL Server backup directory.
WORKAROUND 1:
In the SSMS User interface, right click on Object explorer's server menu, select Facets, select "Server" facet, set the value for BackupDirectory in the property grid and click Ok.
By changing the Native SQL Server default backup folder, LiteSpeed will read this setting (if the LiteSpeed folder hs not been changed). You can change the backup location here - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer
The key name is BackupDirectory - you can change it to any other folder.
To determine where SQL Server is installed you can right click on the server name, select Properties. The root directory as highlighted below will show you the corresponding install name for the instance such as "MSSQL2" highlighted below, so you know which registry entry needs to be changed.
Additional Information:
NOTE - To read the value from the registry:
DECLARE@BackupDirectoryVARCHAR(100)
EXECmaster..xp_regread@rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer',
@value_name='BackupDirectory',
@BackupDirectory=@BackupDirectoryOUTPUT
SELECT@BackupDirectory
ALSO -- to change this back to the default folder we can use the following command
EXECmaster..xp_regwrite |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center