SQL Server:我应该将数据库放在哪里,以便它出现在列表框中
我正在尝试恢复数据库,
但收到此提示,但是我无法指向要从中恢复的数据库还有
其他人遇到过这个可怕的问题吗?
替代文本 http://img686.imageshack.us/img686/6569/56091244.png< /a>
I am trying to restore a DB
I am getting this prompt, however I am unable to point to a database to restore from
Has anyone else experienced this horrific problem?
alt text http://img686.imageshack.us/img686/6569/56091244.png
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
假设您将数据库备份到文件,请单击从设备单选按钮和按照说明操作。
Assuming you backed up a database to a file, click the From device radio button and follow the instructions.
在后端可能会困扰您的一件事是 SQL Server 备份将包含它想要恢复到的路径(原始路径)。
如果您选择备份文件,请确保选中
恢复
列中的复选框,然后单击左侧的选项
页面:完成后,您应该会看到 SQL Server 想要将数据和日志文件恢复到的路径 - 您可能需要根据您自己的计算机情况进行调整:
One thing that might bite you in the backend is the fact that the SQL Server backup will contain the path where it wants to be restored to (the original paths).
If you select your backup file, make sure to select the checkbox in the
Restore
column, and then click on theOptions
page on the left:Once you do, you should see the path where SQL Server wants to restore the data and log files to - you might need to adapt that to your own situation on your machine:
这是不对的。您需要阅读 OMG Ponies 之前发布的文章:SQL Server:如何做我导出整个数据库?。您需要选择“来自设备”,然后选择“从文件”并从您创建的备份文件中浏览“。您听起来像个菜鸟,所以在处理此数据库时要小心。
This is not right. You need to read the article OMG Ponies posted earlier: SQL Server: how do I export entire database?. You need to select "From Device", then from file and browse from the backup file you created". You sound like a noob, so be careful when handling this database.