Lost data forget how to process the backup [graphic] 1th 2 page _mssql

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.