Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql-server

sql-server-2005

configuration

ssms

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 ?

like image 351
KyleLanser Avatar asked Sep 23 '08 21:09

KyleLanser

People also ask

How do I change the default backup location in SQL Server?

Right-click the SQL Server instance and select Properties. Select the Database Settings section. At the bottom of this window, you should see the Backup default location. Browse to the new Backup location and then close.

Where are SQL Server backups stored by default?

The default backup directory is C:\Program Files\Microsoft SQL Server\MSSQL. n\MSSQL\Backup, where n is the number of the server instance. Therefore, for the default server instance, the default backup directory is: C:\Program Files\Microsoft SQL Server\MSSQL13. MSSQLSERVER\MSSQL\Backup.

How do I restore a SQL database to a different location?

To specify the new location of the database files, select the Files page, and then select Relocate all files to folder. Provide a new location for the Data file folder and Log file folder. For more information about this grid, see Restore Database (Files Page).

1 Answers

In the registry, edit the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory value to point to d:\data\databases

like image 93
henriksen Avatar answered Nov 15 '22 18:11

henriksen
Sign in to Comment

Related questions

How do I connect to a MSSQL database using Perl's DBI module in Windows?
bulk insert with or without index
Why are my SQL indexes being ignored?
What are the advantages or disadvantages of switching to JTDS driver from Microsoft jdbc driver? [closed]
SqlDataReader inside SqlDataReader
Upload a file to a varbinary with SQL Management Studio
Algorithm for almost similar values search
Should primary keys be always assigned as clustered index
SQL: What is better a Bit or a char(1)
SQL Server: alter table, how to add SPARSE definition
How to add identity to the column in SQL Server?
How to avoid duplicated FETCH in T-SQL when using a cursor?
SQL Server Passthrough query as basis for a DAO recordset in Access
'Script Table as' in SSMS Not Preserving Collation
How to split string and insert values into table in SQL Server
Create column and insert into it within the same transaction?
XQuery [nodes()]: Syntax error near '<eof>', expected a step expression
sql varchar(max) vs varchar(fix)
Convert scientific notation back to numbers in SQL Server
UPDATE based on if value exist in another table

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!