我无法将sql server 2005数据库还原到sql server 2005 [英] i cant restore sql server 2005 database to sql server 2005

问题描述

我想将数据库从sql server 2005还原到sql server2000.
要还原它显示错误.这对于托管非常重要.
预先感谢.

i want to restore a database from sql server 2005 to sql server 2000. when i am
going to restore it is showing error. this is very essential for to host.
Thanks in advance.

推荐答案

1.转到对象浏览器，然后右键单击数据库，然后选择还原数据库"选项.
2.选择要在其中还原的数据库，并从设备添加反向文件.
3.从lhs中选择选项按钮.
4.更改filename.mdf和filename.mdf
5.选择覆盖选项.

1. goto object explorer and rightclick on databases and select restore database option.
2. select database in which to restore and add backfile from device.
3. select options button from lhs.
4. change filename.mdf and filename.mdf
5. select overwrite option.

即使我单击以强制覆盖也无法恢复.

cant restore even i clicked to force to overwrite also.

这篇关于我无法将sql server 2005数据库还原到sql server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！