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.
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:
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.
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.
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>
Question: How to Forecast the Size of Restore of Backup in SQL Server? Answer: Recently, I had discussed this in consulting engagement.
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)