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)
 Database backup Error

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-02-06 : 21:08:46
I am getting this error after taking backup and while verifying the back up file

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.

Pls help how to over come this error.

-Gangadhar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-06 : 21:17:33
Do you have disk errors in the event log?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-02-06 : 23:37:34

Hi tara,

no disk error in event log as such.


-Ganga
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-07 : 04:01:26
Something damaged the backup after it was taken, probably an IO subsystem problem of some form.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -