RESTORE VERIFY ONLY
The following works in in 1:07 (min:sec) to backup a 3.2 GB database, compressed 83%:
EXEC master..sqlbackup '-SQL "BACKUP DATABASE [ACS] TO
DISK = ''I:\MSSQL\SQLBackups\ACS\ACS_201006012032_FULL_F.SQB''
NAME = ''<DATABASE>-Full Database Backup'',
DESCRIPTION = ''<DATABASE>-Full Database Backup'',
ERASEFILES = 13,
FILEOPTIONS = 5,
COMPRESSION = 3,
THREADCOUNT = 2"'
If I use the VERIFY command as part of the BACKUP command, it hangs indefinitely.
Likewise, if I issue the following command to verify it after the backup command has worked successfully with the VERIFY command, it hangs indefinitely. At the moment it has been running for 20 minutes
EXEC master..sqlbackup '-SQL "RESTORE VERIFYONLY
FROM DISK = ''I:\MSSQL\SQLBackups\ACS\ACS_201006012032_FULL_F.SQB''
WITH CHECKSUM" '
Backups are now being done to a local drive. Previously they had been done to a network drive via UNC path and I thought that was part of the problem. This rules that out.
We are running version 22.214.171.124 using SQL Server 2005, version 9.0.4053.
Thanks for your help.