Issue with VERIFYONLY backup command

I am running SQL Server 2005 sp3. I do a backup with checksum. I then do restore verifyonly. This command is just hanging. Anyway to find out why or anyone know what may be going on?
more ▼

asked Aug 07, 2012 at 03:35 PM in Default

BillBusking gravatar image

0 1 1 1

Is this a user database or system, not that it should matter? Does it happen on any backup file you try or just a particular one?
Aug 08, 2012 at 01:28 AM Shawn_Melton

Did you try restoring the backup? How much time that takes? What are the wait stats at the time of verifying? Can you please share the actual command you are running?

BTW, With checksum the restore verifyonly does take a bit more time.

But most importantly do not take this command as a reliable resource. The best way to verify a backup is to restore it.
Aug 08, 2012 at 06:30 AM Usman Butt
did not try to restore because the restore verifyonly command never ended. Commands used were BACKUP DATABASE [ACS] TO DISK = N'H:\SQLBK2FS\MCKSQL3VS1\ACS\FULL\file_name.bak' WITH CHECKSUM and then run RESTORE VERIFYONLY FROM DISK = N'H:\SQLBK2FS\MCKSQL3VS1\ACS\FULL\file_name.bak'
Aug 08, 2012 at 12:42 PM BillBusking
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
How big is the backup? Assuming it's less than a 1TB this command usually returns extremely quickly. Can you see if it's blocked by a process or if it's waiting for something? Use sys.dm_exec_requests to see the processes that are currently running.
more ▼

answered Aug 07, 2012 at 07:14 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Database is VERY small. Nothing is blocking it
Aug 07, 2012 at 10:25 PM BillBusking
Is there a wait state for the process? There must be some indication why things are running long.
Aug 08, 2012 at 09:50 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 07, 2012 at 03:35 PM

Seen: 1180 times

Last Updated: Aug 08, 2012 at 12:42 PM