Verify Database Backup

I was working with a new computer system. I had made a backup of the database. But could I rely on it?

To confirm the first run of a database backup I wanted to test/verify it was OK.

What I didn’t want to do was to restore the database over the existing one, without the assurance that I wouldn’t be losing data. Too risky!

From within the SQL Server Management Studio. Click to run New Query. I ran the following:

RESTORE VERIFYONLY FROM DISK = 'restore verifyonly from disk = 'Z:\Backup\project1.bak'

You may have to wait a while for the verification process to run.

Here’s an example output showing that the database backup is good to be used:

The backup set on file 1 is valid.

A simple command to run, with a lot of reassurance as a result.

References

RESTORE Statements
Checking to make sure a SQL Server backup is useable