What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283

Question: What does Verify Backup When Finished do in SQL Server?

Answer: It will check up if the backup media is in the place and also checked the header information to make sure that it looks like the header of the backup file.

What does Verify Backup When Finished do in SQL Server? - Interview Question of the Week #283 VerifyBackup-800x440

While it looks like a very important step in the entire backup and restores operation honestly, I consider it just a great start. If you have only specified this option while taking your backup, actually, you have a great start but you can do much more if you have also enabled performing checksum along with it. Contradictory to what many people think this option of Verify Backup When Finished, does not do any integrity check.

Remember that the option of verifying backup only checks limited header information of the backup. It is very much possible for back to get validated (verified or passed) the test of VerifyOnly but during restore, you may still face errors.

Final Suggestion – Verify Backup

If you are really serious about your SQL Server backup, I strongly recommend that you have a routine where you go and restore your backup to your server frequently. There is no better test then restoring the database on the server. If your restore is successful, you have passed your test, otherwise, no matter what feature you have enabled, there are always chances of the disaster.

Here are few recent blog posts on similar topics:

SQL SERVER – Restore Database With Just Log File

Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news. It is not possible.

How to Know Backup Speed in SQL Server? – Interview Question of the Week #277

Question: How to Know Backup Speed in SQL Server?
Answer: It is very simple to know the backup speed in SQL Server. Let us discuss today.

SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally

Let us fix today – Msg 3254 The volume on device <path\file>is empty. Followed by Msg 3013 – RESTORE DATABASE is terminating abnormally.</path\file>

How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265

Question: How to Forecast the Size of Restore of Backup in SQL Server? Answer: Recently, I had discussed this in consulting engagement.

SQL SERVER – Drop failed for Availability Group – Failed to Destroy the Windows Server Failover Clustering Group Corresponding to Availability Group

While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for quick consultation using On-Demand offering.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282

Related Posts

Leave a Reply

Menu