先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
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