Environment Description:
A company installed a SQL Server database, to ensure that the database can be repaired in a timely manner, the administrator does a backup operation, such as full backup + differential or full backup + transaction log backup, and the time of backup is to do a full backup every 6 hours, at 1, 6 points, 12, 18, and within 6 hours, a differential or transaction log backup is made every 1 hours, combined with scheduled tasks.
If there is a scenario where, at around 2:40, suddenly the database is corrupted, a differential backup or a transaction log backup is not automatically done by 3 o'clock, then how do you recover data from 2 to 2? This requires recovery through the backup tail log.
Implementation steps:
1, first create a database, and in the database to create a table Dreamfire do test.
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005144567.jpg" border="0">数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005144567.jpg" border="0">
2. Second, create two backup devices (where backup data is stored), a full backup of the data, a differential backup of the data. Do a full backup + differential backup, if full backup at 1 points to do a full backup, 2 points to do differential backup.
Make a full backup first:
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005144469.jpg" border="0">
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005144982.jpg" border="0">
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005147165.jpg" border="0">
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005147357.jpg" border="0">
After you have completed your full backup, add a piece of data to the table in the database you just created to test.
The database is then backed up by a differential:
数据库没有备份---应如何还原丢失的数据" src="yun_qi_img/20090617005147674.jpg" border="0">
Current 1/2 page
12 Next read the full text