restore database demo from disk='f:\050606' with norecovery,replace, move 'test_data' to 'c:\program files\microsoft sql server\mssql\data\test.mdf', move 'test_log' to 'c:\program files\microsoft sql server\mssql\data\test_log.ldf'gouse test go select * from table1
这样修改; restore database demo from disk='f:\050606' with recovery,replace, --norecovery是要进一步还原 move 'test_data' to 'c:\program files\microsoft sql server\mssql\data\test.mdf', move 'test_log' to 'c:\program files\microsoft sql server\mssql\data\test_log.ldf' use test go select * from table1
from disk='f:\050606'
with norecovery,replace,
move 'test_data' to 'c:\program files\microsoft sql server\mssql\data\test.mdf',
move 'test_log' to 'c:\program files\microsoft sql server\mssql\data\test_log.ldf'gouse test
go
select * from table1
restore database demo
from disk='f:\050606'
with recovery,replace, --norecovery是要进一步还原
move 'test_data' to 'c:\program files\microsoft sql server\mssql\data\test.mdf',
move 'test_log' to 'c:\program files\microsoft sql server\mssql\data\test_log.ldf'
use test
go
select * from table1
restore database demo
with recovery