スポンサーリンク
リコレ!ソフマップの中古通販サイト
スポンサーリンク
デル株式会社

SQLServer2008で、差分バックアップを使って、DBを復元する際の手順メモ

SQL Server 2008

Restore Full backup
1.Open the Restore Database window in Microsoft SQL Server Management Studio
2.Ensure the To database field is filled in with the name you want.
3.Choose From device as the Source for restore.
4.Choose the full backup file you want to restore. In most cases this is the most recent full backup file.
5.Click the Options page on the left navigation.
6.Choose Leave the database non-operational, and do not roll back uncommitted transactions. Additional transaction logs can be restored.(RESTORE WITH NORECOVERY). This is the most important step!!!

Restore Differential backup
1.Open the Restore Database window in Microsoft SQL Server Management Studio
2.Ensure the To database field is filled in with the name you want. The same that you specified in step 2 for the Restore Full backup
3.Choose From device as the Source for restore.
4.Choose the differential backup file you want to restore. In most cases this is the most recent differential backup file.
5.Click the Options page on the left navigation.
6.Choose the default: Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored.(RESTORE WITH RECOVERY) Make sure to choose this if you want to use your database after the restore.

The log or differential backup cannot be restored because no files are ready to rollforward.
If you have found this page, it is likely that you encountered the following error when you tried to restore a differential backup using Mic...

 

 

コメント

スポンサーリンク
明日を、もっと、ハッピーに!『ショップジャパン』
スポンサーリンク
au PAY マーケット
タイトルとURLをコピーしました