question

BillBusking avatar image
BillBusking asked

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?
sql-server-2005backup
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
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.
1 Like 1 ·
Shawn_Melton avatar image Shawn_Melton commented ·
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?
0 Likes 0 ·
BillBusking avatar image BillBusking commented ·
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'
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

BillBusking avatar image BillBusking commented ·
Database is VERY small. Nothing is blocking it
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Is there a wait state for the process? There must be some indication why things are running long.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.