I need to restore a DB from a .BAK-file that is not located on the server, but on my local machine.
我需要从.BAK文件中恢复数据库,该文件不在服务器上,而是在我的本地计算机上。
Normally I remote desktop to the SQL server, copy the .BAK-file, and do the restore that way with Management Studio. This feels a bit awkward though, especially on days like this, when I get thrown out because the number of allowed connections has been reached on remote desktop.
通常我是远程桌面到SQL服务器,复制.BAK文件,然后使用Management Studio进行恢复。这感觉有点尴尬,特别是在这样的日子里,当我因为在远程桌面上达到允许的连接数而被抛出时。
I'd like to restore the DB from a file on my local machine, with Management Studio. I can connect to SQL server via Management Studio, but when I do Tasks -> Restore -> Database and choose file, it only lets me browse the file system of the server.
我想通过Management Studio从本地计算机上的文件恢复数据库。我可以通过Management Studio连接到SQL服务器,但是当我执行任务 - >恢复 - >数据库并选择文件时,它只允许我浏览服务器的文件系统。
Is there any way to make it look for the .BAK on my local file system?
有没有办法让它在我的本地文件系统上查找.BAK?
1 个解决方案
#1
I assume this is a one time occasion and not a permanent fix
我认为这是一次性而非永久性修复
Can you access your local systems drive via the server?
e.g.
您可以通过服务器访问本地系统驱动器吗?例如
\\yourpcnumber\c$
Otherwise why don't you just copy the file to the server?
否则你为什么不把文件复制到服务器?
#1
I assume this is a one time occasion and not a permanent fix
我认为这是一次性而非永久性修复
Can you access your local systems drive via the server?
e.g.
您可以通过服务器访问本地系统驱动器吗?例如
\\yourpcnumber\c$
Otherwise why don't you just copy the file to the server?
否则你为什么不把文件复制到服务器?