5.verifybackup.sql

SQL Server 2005基础教程一书的源代码.

DECLARE @BackupSet AS INT
SELECT @BackupSet = position 
  FROM msdb..backupset 
 WHERE database_name='ApressFinancial' 
   AND backup_set_id=
                        (SELECT MAX(backup_set_id) 
                        FROM msdb..backupset 
                       WHERE database_name='ApressFinancial' )
IF @BackupSet IS NULL 
BEGIN 
    RAISERROR('Verify failed. Backup information for database''ApressFinancial'' not found.', 16, 1) 
END
RESTORE VERIFYONLY 
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ApressFinancial.bak' 
WITH FILE = @BackupSet,  
NOUNLOAD,  
NOREWIND