How to verify the backup

Posted: February 23, 2009 in Sqlserver

Please use below query to validate the backup is good or not.

This is very important to make your job easy and safe, verify all your backups every week. There are so many methods to do that other then sql native method.

This query can help you to verify the backup are valid or not.

 

RESTORE VERIFYONLY FROM  DISK = N’d:\perfmonitor_backup_2009_02_23_133557_9980470.bak’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s