将数据库备份文件连接到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屋！