先verify数据库备份文件, 再执行数据库恢复

RESTORE VERIFYONLY
FROM DISK='C:\1.bak'
GO

IF @@ERROR = 0
BEGIN
RESTORE DATABASE MyDatabase
FROM DISK='C:\1.bak'
END
ELSE
BEGIN
PRINT 'Cannot restore from backup'
END
GO

T-SQL Verify Database Backup