net stop MSSQLSERVER
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -m
osql -S localhost -E
Password:
1)restore database master from disk="D:\master.bak"
2)go
restore database xxx from disk="D:\xxx.bak" with norecovery
restore log xxx from disk="D:\xxx.trn" with norecovery
restore log xxx from disk="D:\xxx.trn"
use sa
osql -S localhost -U sa
指定還原時間
http://www.dotblogs.com.tw/wjl0127/archive/2011/09/27/37946.aspx