将数据库备份文件连接到SQL Server 2008 [英] To connect the database backup file to SQL server 2008
问题描述
大家好,
我刚刚在计算机上安装了SQL Server 2008 R2 expres版本.
正在从SQL Server 2000获得数据库备用文件.
现在,我想将该数据库附加到SQL Server2008.
如果我遵循数据库附加的常规程序,它会给我
以下错误:
无法检索此request()的数据
执行Transact-SQL或Bach时发生异常.
谁能知道解决问题的方法还是
如何将我的数据库附加到Managment Studio ??
我是使用SQL Server的新手,如果可以的话请帮帮我
在此先谢谢
Yogesh
Hello all,
I just installed the SQL Server 2008 R2 expres edition on my machine.
Am having database backfile from SQL server 2000.
Now i want to attach that datbase to the SQL server 2008.
If i follow the regular procedure of attachment of database it give me
the following error:
Failed to retrive the data for this request()
An exception occured while executing Transact-SQL or Bach.
So can anybody knows that how to solve the problem or
how do i attach my database to the Managment studio???
I am new to using SQL server please help me if you can
Thanks In advance
Yogesh
推荐答案
尝试RESTORE命令.
http://msdn.microsoft.com/en-us/library/ms186858.aspx [ ^ ]
Try the RESTORE command.
http://msdn.microsoft.com/en-us/library/ms186858.aspx[^]
这篇关于将数据库备份文件连接到SQL Server 2008的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!