RESTORE detected an error on page (0:0) in database

Source: Internet
Author: User

the test server encountered the following error while restoring a database for the production server:

System.Data.SqlClient.SqlError:RESTORE detected an error on page (0:0) in database "XXXX" as read from the backup set. (Microsoft.SqlServer.SmoExtended)

when validating a database backup (verfify backup Media), the following error is reported:
Backup Media Verification failed:xxxxx (Microsoft.SqlServer.Management.RelationalEngineTasks)

Since the backup file was uploaded from HK over the fileconnect, there may be intermediate network problems or other factors that caused the backup file to be corrupted, as it has previously encountered a Fileconnect extract file to find the file corruption. The system administrator gave me a way to verify that the Fileconnect file is corrupted, first compress the database backup file, then upload to Fileconnect, and then get the compressed file from the database backup, if the decompression is normal, the file is not corrupted, if the decompression error, Indicates that the file is corrupted. During the test, it was found that the file was damaged.

RESTORE detected an error on page (0:0) in database

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.