Friday, March 30, 2012

How to verify database backup completed?

Hello, everyone:
Does any baby offer command to verify if database backup is completed? In backup wazard, there is an option "Verify backup upon completion" . Is there the SQL command? Thanks.
ZYTWhen this is checked, it runs the following after the backup is completed.

RESTORE VERIFYONLY FROM DISK = 'backupfile.bak'

No comments:

Post a Comment