问题描述
我在本地计算机上创建了一个数据库，然后执行了表DataLabTables的名为tables.bak的备份.
I created a database on my local machine and then did a backup called tables.bak of table DataLabTables.
我将该备份移到了没有该表的远程计算机上，并试图进行还原，但是出现以下错误:
I moved that backup to a remote machine without that table and tried to do a restore but get the following error:
如果这是问题所在，我该如何解决我的权利?
How do I fix my rights, if that is the problem?
推荐答案
我刚在SQL Server 2012中遇到此问题.
I have just had this issue with SQL Server 2012.
事实证明，我要做的就是勾选文件"部分中标记为将所有文件重定位到文件夹"的框:
It turns out all I had to do was tick the box marked 'Relocate all files to folder' on the 'Files' section:
(单击以查看完整尺寸的图像)
(Click to see image full size)
这当然是假定您安装了正确版本的SQL Server.
This of course assumes you have the correct version of SQL Server installed.
这篇关于SQL Server还原错误-拒绝访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！