T-SQL Verify Database Backup
先verify資料庫備份檔案, 再執行資料庫恢復
<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
-->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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16436858/viewspace-659448/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle full database backupOracleDatabase
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase
- Cold backup and restore the entire databaseRESTDatabase
- rman backup database force 功能Database
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- How to use rman backup a noarchivelog databaseHiveDatabase
- CDH5之Unexpected error.Unable to verify database connectionH5ErrorDatabase
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- 理解RMAN backup database plus archivelog命令DatabaseHive
- recover database using backup controlfileDatabase
- recover database using backup controlfile與 recover database 的區別Database
- recover database using backup controlfile理解Database
- recover database using backup control fileDatabase
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- SQL SERVER BACKUP DATABASE 加快備份速度方法SQLServerDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- recover database until cancel using backup controlfileDatabase
- Recover database using backup controlfile until cancelDatabase
- alter database backup controlfile to trace的問題Database
- alter database backup controlfile to trace的含義Database
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- 重建控制檔案--alter database backup controlfile to traceDatabase
- oracle database backup and recovery user's guide part VII & VIIIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part V & VIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part I & IIOracleDatabaseGUIIDE
- RMAN10g: backup copy of database (Doc ID 266980.1)Database
- oracle create a new database using backup controlfile to traceOracleDatabase
- Oracle 12C Transport a Database to a Different Platform Using Backup SetsOracleDatabasePlatform
- SQL SERVER恢復資料錯誤解決:The backup set holds a backup of a database other than the existingSQLServerDatabase
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:DATABASE子句SQLServerDatabase
- [AlwaysOn] 建立SQL Server高可用性組T-SQL語法:BACKUP_PRIORITY引數SQLServer
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM