同意楼上的朋友: Use Master restore DATABASE mydb from disk='c:\my.bak'
: forgot2000(忘记2000年)老兄说的对
用企业管理器里的restore database
1、停掉SQL Server的服务,再重新启动 2、再查询分析器中执行 Use Master Restore Database mydb From Disk='c:\my.bak'
1.in Sql Server EnterPrise manager ,right click sql server name ,then click property ,at connections tabStrip Set Allow other sql server to conntect remotely to this sql server to False, click ok 2.restart you sql server. 3.if you have been opened Sql Query Analyzer or Sql Profiler then Close it . 4.Restore your DataBase.
Use Master
restore DATABASE mydb from disk='c:\my.bak'
2、再查询分析器中执行
Use Master
Restore Database mydb From Disk='c:\my.bak'
2.restart you sql server.
3.if you have been opened Sql Query Analyzer or Sql Profiler then Close it .
4.Restore your DataBase.
http://www.csdn.net/expert/topic/701/701403.xml?temp=.7961542
restore DATABASE mydb from disk='c:\my.bak';
alter DATABASE mydb set MULTI_USER;