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.
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.
NOTE - To read the value from the registry:
@key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer',
ALSO -- to change this back to the default folder we can use the following command