Thursday, November 11, 2010

How To Verify The SQL Backup File?

Here is a list of commands to verify the backup files in sql server. 

1.  Execute below command for finding the backup set is complete and that all volumes are readable. 

Restore verifyonly from disk='C:\MSSQL\adventureworks.bak' 

2.  Execute below command for finding the backup header information for all backup sets on a particular backup device.

Restore headeronly from disk='C:\MSSQL\adventureworks.bak' 

3.  Execute below command for finding the database and log files contained in the backup set.

Restore filelistonly from disk='C:\MSSQL\adventureworks.bak'
RESTORE VERIFYONLY.  VERIFYONLY and CHECKSUM help. Verifying Backups with the RESTORE VERIFYONLY Statement. How reliable is RESTORE VERIFYONLY. RESTORE VERIFYONLY OUTPUT. how to verify backup file. Microsoft SQL Server Restore HeaderOnly. VerifyOnly. FilelistOnly. RESTORE VERIFYONLY FROM DISK SQL SERVER LEARNER. SQL Server interview question and answers. Verifying backup files. RESTORE VERIFYONLY In SQL Server 2005. RESTORE VERIFYONLY In SQL Server 2008. RESTORE VERIFYONLY In SQL Server 2012. Syntex for restore filelistonly & restore verifyonly. SQL Maint Backup verify vs backup verifyonly. Legato back-up solutions. Verify only. in sql server 2012.

2 comments:

How to check for Transactional and differential backup files?

4.Execute below command for showing software name,Media set in backup
RESTORE LABELONLY FROM DISK='C:\MSSQL\Adventureworks.BAK'

Post a Comment