附加远程存储的数据库 [英] Attach a remotely stored database

问题描述

可以附加存储在远程服务器上的数据库，因为在映射驱动器并尝试将其附加到Management Studio时，驱动器不会显示为选项。我移动它是因为磁盘空间，如果我不能的替代建议是什么？

Is it possible to attach a database that is stored on a remote server because when I mapped a drive and tried to attach it in management studio, the drive does not show up as an option. I moved it because of disk space and if I cannot what is the alternative suggestions?

推荐答案

你应该能够附加一个数据库在UNC路径（我不会使用映射的驱动器 - 该驱动器为您映射，而不是SQL Server服务帐户），但必须确保SQL Server服务帐户对远程文件夹具有读/写权限，您必须运行跟踪标志1807（请阅读Brent Ozar的有关此的帖子。）

You should be able to attach a database on UNC path (I wouldn't use a mapped drive - that drive is mapped for you, not the SQL Server service account), but you have to ensure that the SQL Server service account has read/write permissions on the remote folder, and you have to run trace flag 1807 (please read Brent Ozar's post about this).

也不要使用GUI。设置跟踪标志，重新启动服务并正确配置权限后，使用新的查询窗口，然后运行以下命令：

Also don't use the GUI for this. Once you have the trace flag set, have restarted the service, and have configured permissions correctly, use a new query window, and run the following command:

CREATE DATABASE db_name 
ON (Filename = '\\uncpath\share\file.mdf'),
   (Filename = '\\uncpath\share\file.ldf')
FOR ATTACH;

（UI不会为您提供UNC路径，无论您设置了什么跟踪标志，启用了哪些权限。）

(The UI is never going to offer you a UNC path no matter what trace flags you have set or what permissions are enabled.)

当然，如果网络共享下降，请准备处理已损坏且可能无法恢复的数据库。

Be prepared to handle a corrupted and possibly unrecoverable database should the network share go down, of course.

如果这听起来很可怕，好吧！这应该！这不是一个好主意。相反，您应该释放一些空间，添加驱动器或在不同的实例上托管数据库。

If that sounds scary to you, good! It should! This is not a good idea at all. Instead you should free up some space, add a drive, or host the database on a different instance.

这篇关于附加远程存储的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！