先verify数据库备份文件, 再执行数据库恢复
RESTORE VERIFYONLYFROM DISK='C:\1.bak'GOIF @@ERROR = 0BEGINRESTORE DATABASE MyDatabaseFROM DISK='C:\1.bak'ENDELSEBEGINPRINT 'Cannot restore from backup'ENDGO