sql-server - 确保备份功能齐全

Question

这就是我计划备份数据库的方式。如何检查创建的备份是否功能齐全？

BACKUP DATABASE mytest TO DISK = 'C:\mytest.BAK'

Answer 1

检查 RESTORE VERIFYONLY -

BACKUP DATABASE [db] TO DISK = N'D:\BACKUP\db.bak'
GO
DECLARE @backupSetId AS INT
SELECT @backupSetId = position
FROM msdb.dbo.backupset
WHERE database_name = N'db'
    AND backup_set_id = (
        SELECT MAX(backup_set_id)
        FROM msdb.dbo.backupset
        WHERE database_name = N'db'
    )
IF @backupSetId IS NOT NULL
BEGIN
    RESTORE VERIFYONLY FROM DISK = N'D:\BACKUP\db.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
END