December 10, 2010 at 4:32 am
Hi Guys,
Initially the backup job was taking too long to complete(10-11 hours for 50 databases).
So, we decided to verify the backups seperately after the Backups are complete.
Here is the issue: Now the job which verifies the Backups through a cursor using "xp_restore_verifyonly" is taking too long to complete.
Now Backups are completed in 4-4.5 hours but then Verifying is taking 10-11 hours.
( we are taking Backups through Litespeed)
Is there solution to this ?
Kindly help me in this situation
December 12, 2010 at 10:49 am
'xp_restore_verifyonly' in turn makes use of RESTORE VERIFYONLY command. VERIFYONLY will verify that the backup set is valid. More details here.
The time it takes to verify the backup is always longer and it is by design. As I have seen VERIFY command takes more time than it took to backup the database.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 13, 2010 at 10:36 am
do a waitstats analysis and file IO stall analysis to determine the actual cause of the slowness, and then address that.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply