Use master exec master..xp_cmdshell 'net use \\10.0.0.1\d$ Password /user:administrator' Go Restore database BIL from disk='\\10.0.0.1\d$\backup\file.bak' with recovery, move 'DBNAME_DATA' to 'd:\NEWData\DBNAME_DATA.mdf', move 'DBNAME_Log' to 'd:\NEWData\DBNAME_log.ldf'
Use master exec master..xp_cmdshell 'net use \\10.0.0.1\d$ Password /user:administrator' Go Restore database DANME from disk='\\10.0.0.1\d$\backup\file.bak' with recovery, move 'DBNAME_DATA' to 'd:\NEWData\DBNAME_DATA.mdf', move 'DBNAME_Log' to 'd:\NEWData\DBNAME_log.ldf'
Use master
exec master..xp_cmdshell 'net use \\10.0.0.1\d$ Password /user:administrator'
Go
Restore database BIL from disk='\\10.0.0.1\d$\backup\file.bak'
with recovery,
move 'DBNAME_DATA' to 'd:\NEWData\DBNAME_DATA.mdf',
move 'DBNAME_Log' to 'd:\NEWData\DBNAME_log.ldf'
Use master
exec master..xp_cmdshell 'net use \\10.0.0.1\d$ Password /user:administrator'
Go
Restore database DANME from disk='\\10.0.0.1\d$\backup\file.bak'
with recovery,
move 'DBNAME_DATA' to 'd:\NEWData\DBNAME_DATA.mdf',
move 'DBNAME_Log' to 'd:\NEWData\DBNAME_log.ldf'
参考[MSDN]ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.zh-CHS/udb9/html/7982a687-980a-4eb8-8e9f-6894148e7d8c.htm
2、具体恢复时使用的代码如下:
把A文件移动到B处
A可以是数据文件,也可以是日志文件