更改备份位置的默认目录

时间:2021-05-19 16:59:30

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

使用MS SQL Server Management Studio 2005 -恢复数据库:

  • 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

那个窗口默认C:\Program Files\Microsoft SQL Server \ MSSQL.1 \备份

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 Management Studio女士在D:\ \ \数据库中的数据,而不是在C:\Program Files\Microsoft SQL Server \该软件。1 \备份?

3 个解决方案

#1


15  

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

在注册表中,编辑HKEY_LOCAL_MACHINE\软件\Microsoft\ SQL Server\MSSQL。\MSSQLServer\BackupDirectory值指向d:\数据\数据库

#2


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

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

There is a registry key named BackupDirectory

有一个名为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.

我怀疑注册表键会在不同的位置(我有64位vista)。我在我的注册表中搜索了“MSSQL.1\Backup”以找到它。

#3


4  

For convenience, here's a reg file entry to do this:

为了方便起见,这里有一个reg文件条目:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"BackupDirectory"="D:\\data\\databases\\"

#1


15  

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

在注册表中,编辑HKEY_LOCAL_MACHINE\软件\Microsoft\ SQL Server\MSSQL。\MSSQLServer\BackupDirectory值指向d:\数据\数据库

#2


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

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

There is a registry key named BackupDirectory

有一个名为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.

我怀疑注册表键会在不同的位置(我有64位vista)。我在我的注册表中搜索了“MSSQL.1\Backup”以找到它。

#3


4  

For convenience, here's a reg file entry to do this:

为了方便起见,这里有一个reg文件条目:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"BackupDirectory"="D:\\data\\databases\\"