July 14, 2011 at 10:51 pm
Dear All,
I am taking a full back up from production environment it close to &&GB on SQL server 2005 Enterprise edition through management studio.
After that i am trying to verify the back up.
RESTORE VERIFYONLY FROM DISK = 'E:\EE\database\backup\EE_Fullbackup_15072011.bak'
It is throwing the following error pls advice how to fix this issue.
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.
July 15, 2011 at 1:53 am
Gangadhara,
From the error message it appears that the backup set is invalid. The only option it fix this is to initiate a new backup.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 15, 2011 at 3:07 am
Hi Pradeep,
Yes you said i have initiated the New backup and successfully i have taken backup.
Even after doing the tran log back up i have done the Full backup again and its now 76GB.
When i run the verify back up query i am gettign below error in spite of that we have 230 GB of free space in the Disk drive,
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Msg 701, Level 17, State 17, Line 1
There is insufficient system memory to run this query.
July 15, 2011 at 11:11 am
Hi Gangadhar,
Now backup verification is failing because of "There is insufficient system memory to run this query" error. SQL Server is running out of memory. You may try the backup verification after the instance/server is restarted.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 15, 2011 at 1:52 pm
Hi Gangadhara
check the sql server log, are you seeing any other specific errors there around the time the RESTORE VERIFYONLY runs?
How much memory does your server (not SQL Server but the Windows server) have total?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2011 at 1:02 am
the systems is having 32 Gb of memory.
I have restarted the service for SQL server,even after restarting sql service instance i am not able to verify the back up.
Could you pls suggest any other method.
July 16, 2011 at 4:12 am
What other errors do you see, if any, in the SQL server log around the time as the verify?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply