Changing SQL default backup location |
Article ID: 1684 |
 Back to Search
|
The target audience for this article is:
- 3Essentials server administrators
- 3Essentials UNMANAGED server/virtual server customers who manage their own server and MSSQL instance.
The SQL server default backup location is stored in the registry, location varies by version:
- SQL 2008
- First you need to determine the InstanceName, so using regedt32 go to:
[HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\]
- Make a note of the default instance name (assuming that's the instance you want to make the change for the backup location). Usually MSSQL10.MSSQLSERVER (the naming convention for instance names was changed from MSSQL.Instance# to MSSQL10.InstanceID which you enter in at install time).
- Now go to the following key, modifying the instance name to whatever your actual instance name is.
[HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\]
- The backup location can be found there in a value named: BackupDirectory
- SQL 2005
- The backup location can be found in the registry in the following key in a value named: BackupDirectory
- [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\]
|
| |
| Downloads Associated With This Article |
| No downloads are currently associated with this article. |
KB
