Alex Rivera | Logout

SQL Server Management Studio 2005 - Change Default Directory for Backup Location

Asked 2008-09-23T21:30:54.997
12

Using MS SQL Server Management Studio 2005 - To Restore a Database:

  • Restore Database
  • (*) From Device:
  • Click "..." Button
  • Backup media: File
  • Click "Add" Button
  • Popup Window: "Locate Backup File"

That window Defaults to C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup

How do I configure MS SQL Server Management Studio to look in D:\data\databases\
instead of looking in C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup ?

sql-server sql-server-2005 configuration ssms
Edit
Report

1 Answer

5

It's stored in the registry.

On my computer, it's at...

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

There is a registry key named BackupDirectory

I suspect the registry key will be in a different location for you (I have 64 bit vista). I did a search in my registry for 'MSSQL.1\Backup' to find it.

answered 2008-09-23T21:48:27.093

Your Answer