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.