Ask Experts Questions for FREE Help !
Ask
    milas73's Avatar
    milas73 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Nov 28, 2014, 08:42 AM
    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.
    InfoJunkie4Life's Avatar
    InfoJunkie4Life Posts: 1,409, Reputation: 81
    Ultra Member
    		  
    #2

    Nov 28, 2014, 12:43 PM
    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
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Sql database connectivity [ 1 Answers ]

Database connectivity with server

Excel - Importing from web or SQL database? [ 5 Answers ]

Ok, I know how to Import from the Web via Excel.. that is not what I am looking for. Here is what I would like to be able to do: We have a system that we can upload a pre-formatted PDF with variables that will pull info from our system. This works great for populating customized contracts. ...

Update of SQL Server database content [ 1 Answers ]

I have database in the web with SQL Server 7.0. Now how can I periodically update the content of the database by simply uploading text file containing the cumulative updates? Can anyone help?

View more questions Search