SQL Server Backup Recovery from: http://sjdwm.blog.51cto.com/445300/140838SQL
Server backup and restoration lab time:
Lab person: Xiao Feng lab name: SQL
Server backup and recovery experiment task and objectives: 1. Back up the database 2. Restore the database experiment environment description: Experiment topology and Network Planning: experiment operation process and configuration instructions:
Tutorial step: Task 1: Back up the database 1. Start the SQL Server service. 2. Create an SJD database and confirm that the recovery mode is complete. 3. Create a table in the SJD database named tab1.
4. Create three backup devices. The backup device nodes on the server-& gt; are named full, diff, and trans respectively.
5. Completely back up the SJD database to the full backup device. Select to overwrite all backup Sets
6. Create a table in the SJD database named tab2.
7. Differential backup of the SJD database to the diff device. Select to overwrite all backup Sets
8. Create a table in the SJD database named tab3.
9. Back up the transaction logs of the SJD database to the Trans backup device. Select to overwrite all backup sets.
10.
Remember a time point. After this time point, create another table in the SJD database and name it tab4.
I created tab4 11 at 11: 31.
Back up the transaction logs of the SJD database to the backup device trans, and select to append to the existing backup.
12. Create another table in the SJD database named tab5.
13. Simulate database corruption, stop the SQL Server service, and delete or rename the primary data file of the Benet database.
14. Restart the SQL Server service
15.
Back up the tail log to the backup device trans and select to append it to the existing media. (Select transaction log backup when backing up, select the backup log tail in the options and make the database restore to back up the tail log) Task 2: Restore the database, in the following operations, right-click the SJD database and choose "Restore database" from the menu. 1. Restore the database. Select "full database backup". After the restoration is complete, check the table in the database and record it.
View only table 1
2. Restore the database. At this time, you must overwrite the existing database to restore the database. Select full backup and differential backup. After the restoration is complete, check the table of the database and record it.
3. Restore the database, overwrite the existing database, and select full backup, differential backup, and the first log backup. After the restoration is complete, check the tables in the database.
