如何还原数据库
问题描述：
我的数据库中有一个mdf文件和日志文件.如何使用此文件还原数据库.请帮助我
I have an mdf file and log file in my database. How to restore the database using this files.Please help me
答
您需要将其附加到数据库服务器.试试这个:
http://msdn.microsoft.com/en-us/library/ms190209.aspx [ ^ ]
希望对您有所帮助:)
You need to attach it to database server. Try this:
http://msdn.microsoft.com/en-us/library/ms190209.aspx[^]
hope it helps :)
尝试一下:
将mdf和日志文件放在C:\ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ Data \
右键单击数据库"->附加"->添加"->选择您的mdf文件路径"->单击确定".
它可能会对您有所帮助.
Try this:
Place the mdf and log files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
Right click on Database->Attach->Add->select your mdf file path->click on "ok".
It may help you.
启动SQL Server Management Studio
右键单击数据库，然后选择ATTACH
Start SQL Server Management Studio
Right click on Databases and choose ATTACH