RESTORE FAILED - error on page (0:0)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

RESTORE FAILED - error on page (0:0)

Author

Topic

Mathias
Posting Yak Master

119 Posts

Posted - 2009-09-07 : 05:26:22

Everyday, I restore the Production database on a staging server. For the last 3 days, I am unable to do it. I have the following error:

Msg 3183, Level 16, State 2, Line 57
RESTORE detected an error on page (0:0) in database "G_Restore" as read from the backup set.
Msg 3013, Level 16, State 1, Line 57
RESTORE DATABASE is terminating abnormally.

What should I do?

This is the command I use:

RESTORE DATABASE G_Restore
FROM DISK = @Backup_File_Path
WITH MOVE 'G_DB_Data' TO @DataBasePhysical,
MOVE 'G_DB_Log' TO @LogPhysical

It runs on SQL Server 2005 and the database is in Full recovery mode with transaction LOG

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-09-07 : 05:39:29

Sounds like your backups are corrupted or you are trying to restore over the wrong database.

Do you verify your backups after taking them?
Is your @Backup_File_Path correctly set?
Are your paths correct?

Mathias
Posting Yak Master

119 Posts

Posted - 2009-09-07 : 05:41:06

I don't verify the backup after taking them. The path is correct. I have the errors after 2hours 30 minutes of restore.

I have DBCC CHECKDB on the original db and it reported no error:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'G_DB'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I have now added a verify tasks after the backup but what else should I do?

learnit
Starting Member

6 Posts

Posted - 2009-09-08 : 02:50:29

have you tried restore the database to a temporary database other than on which you are trying to restore?

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2009-09-08 : 12:43:16

Check backup file:

restore verifyonly
from disk='backupfile path'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources