April 14, 2009 at 9:37 pm
Hi Experts
Im getting the following error while restoring
Restore failed for Server 'MyServer'. (Microsoft.SqlServer.SmoExtended).
System.Data.SqlClient.SqlError: RESTORE detected an error on page (48032:3) in
database "My_DB" as read from the backup set. (Microsoft.SqlServer.Smo)
Can you please help me with this.
Tanx 😀
April 14, 2009 at 10:22 pm
Hi Eswin,
Looks like there was some corruption in the Original database and the same is available in the backup. Hence the restore is failing. Please verify whether the backup is clean by issuing the below command.
RESTORE VERIFYONLY FROM DISK='The Backup Path'
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
April 14, 2009 at 10:46 pm
Can you complete the restore from SSMS? I'm curious if you get anything else.
I too, suspect a corrupt backup. Can you make another backup from the source?
April 14, 2009 at 11:57 pm
Had checked the backup with
RESTORE.........VERIFYONLY
it gave a message
Msg 3189, Level 16, State 1, Line 1
Damage to the backup set was detected.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
even i think the dump is bad.
Tanx 😀
April 15, 2009 at 12:07 am
Is it possible to avoid that particular page and do page restoration.
Can you tell me how to do page restoration.
Tanx 😀
August 22, 2010 at 10:11 pm
Try this
RESTORE DATABASE databasename FROM DISK='database path'
WITH REPLACE, CONTINUE_AFTER_ERROR;
GO;
You can restore and ignore the error page.
Hope it help.
Regards.
February 15, 2011 at 10:19 am
I have the same problem, but when i trie to do:
RESTORE DATABASE SGT1 FROM DISK='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK'
WITH REPLACE, CONTINUE_AFTER_ERROR
i receive the following error:
Msg 3186, Level 16, State 2, Line 1
The backup set has been damaged. RESTORE will not attempt to apply this backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply