当你的Server出现问题时,而你的DB需要继续使用时,怎么办,回复备份数据库啊。单独完整备份 SQL codeRestore Database SQLDB From disk='G:\Backup\Full_20090206.bak' WITH RECOVERY 完整备份后追加差异备份 SQL codeRestore Database SQLDB From disk='G:\Backup\Full_20090206.bak' WITH NORECOVERY Restore Database SQLDB From disk='G:\Backup\Diff_20090209.bak' WITH RECOVERY 完整备份后追加差异备份再追加日志 SQL codeRestore Database SQLDB From disk='G:\Backup\Full_20090206.bak' WITH NORECOVERY Restore Database SQLDB From disk='G:\Backup\Diff_20090209.bak' WITH NORECOVERY Restore Database SQLDB From disk='G:\Backup\Diff_20090210.trn' WITH RECOVERY
SQL codeRestore Database SQLDB
From disk='G:\Backup\Full_20090206.bak'
WITH RECOVERY 完整备份后追加差异备份
SQL codeRestore Database SQLDB
From disk='G:\Backup\Full_20090206.bak'
WITH NORECOVERY
Restore Database SQLDB
From disk='G:\Backup\Diff_20090209.bak'
WITH RECOVERY
完整备份后追加差异备份再追加日志
SQL codeRestore Database SQLDB
From disk='G:\Backup\Full_20090206.bak'
WITH NORECOVERY
Restore Database SQLDB
From disk='G:\Backup\Diff_20090209.bak'
WITH NORECOVERY
Restore Database SQLDB
From disk='G:\Backup\Diff_20090210.trn'
WITH RECOVERY