Idera SqlSafe恢复数据库

EXEC [master].[dbo].[xp_ss_restore]
@database = 'TestDBM',
@filename = 'D:\dumps\TestDBM.BAK',
@managementserver = 'testserver',
@backuptype = 'Full',
@encryptionpassword = 'password',
@withmove = 'TestDBM C:\MSSQL\data\TestDBM.MDF',
@withmove = 'TestDBM_log C:\MSSQL\log\TestDBM_log.LDF',
@recoverymode = null

 

 注意@withmove参数

posted @ 2009-02-07 13:47  代码乱了  阅读(420)  评论(0编辑  收藏