I know that I can verify backup files while the backup itself is running. However, I'm trying to shorten my backup window and would like to run the verify option separately against the backup files. Is that possible?
You can verify backup files at any time by using the RESTORE VERIFYONLY syntax e.g.
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
EXEC master..sqlbackup '-sql "RESTORE VERIFYONLY FROM DISK = [e: emppubs01.sqb]"', @errorcode OUT, @sqlerrorcode OUT
SELECT @errorcode, @sqlerrorcode
You can find the latest backup files from the msdb..backupset and msdb..backupmediafamily tables. The 2 tables are linked using the media_set_id value.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software Beyond compression - SQL Backup goodies under the hood, updated for version 8
Comments
You can find the latest backup files from the msdb..backupset and msdb..backupmediafamily tables. The 2 tables are linked using the media_set_id value.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8