How to deal with lost data missing backups page 1/2

Environment Description:
A company has installed an SQL Server database. To ensure that the database can be repaired in time when a fault occurs, the Administrator backs up the database, for example, full backup + differential backup or full backup + transaction log backup, and the backup time is a full backup every six hours, at, and every day, a differential backup or transaction log backup is performed every one hour within six hours, combined with scheduled tasks.

If such a scenario exists now, suddenly the database is damaged for no reason around 02:40, differential backup or transaction log Backup will be automatically performed, how can we recover data between and? This requires recovery by backing up the tail log.

Implementation steps:

1. Create a database and create a table named Dreamfire in the database for testing.
DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K4064M5-0.jpg "border = 0>
2. Create two backup devices (where backup data is stored), one for full backup data and the other for differential backup data. Perform a full backup + differential backup. If the full backup is complete at, then perform differential backup.

Complete backup:

DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K40B5X-1.jpg "border = 0>
DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K4063117-2.jpg "border = 0>

DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K40631c-3.jpg "border = 0>
DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K4062c2-4.jpg "border = 0>

After completing the full backupDatabaseAdd a piece of data to the table for testing.

Then, differential backup is used.Database:

DatabaseNo backup --- How should I restore lost data "src =" http://www.bkjia.com/uploads/allimg/131021/1K40CQ2-5.jpg "border = 0>