Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Utilities (https://www.askmehelpdesk.com/forumdisplay.php?f=78)
-   -   Error while restoring a Sql Database using MSSQL 2005. (https://www.askmehelpdesk.com/showthread.php?t=805203)

  • Nov 28, 2014, 08:42 AM
    milas73
    Error while restoring a Sql Database using MSSQL 2005.
    When i try to restore a DB from a database backup file i get the following error after 10% of the data has been restored

    System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "dbName" as read from the backup set.(Microsoft.Sqlserver.Smo,

    Does anybody have a fix for this or know what it means? Please help.
  • Nov 28, 2014, 12:43 PM
    InfoJunkie4Life
    Verify the database to see if it is corrupted.

    RESTORE verifyonly FROM DISK='C:\Backup\Mydatabasefullbackup.bak';

    You may also want to ensure that the original database you backed up from is not corrupted.

    DBCC CHECKDB ('XXX') WITH NO_INFOMSGS, ALL_ERRORMSGS;

    on the original machine.

    Here's some info on corrupt databases:
    Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors - Paul S. Randal

  • All times are GMT -7. The time now is 05:03 PM.