January 7, 2015 at 9:20 am
If the database is configured to mirroring and what will happen if we select the check the option of verify backup finish and check the integrity of the backup
Some one mentioned that you can't select that while the db in mirroring
January 7, 2015 at 9:34 am
Verifying the backup is a good way to allow SQL Server to ensure that the backup file is readable once the backup is complete. I have not heard of any reason that you should not use this on a mirrored environment and cannot think of why reading the backup file metadata would affect the mirror. If you are able to keep verify selected then I would encourage you yo keep using that setting.
For more information on verifying backups check out the following link. http://technet.microsoft.com/en-us/library/ms189587%28v=sql.100%29.aspx
January 7, 2015 at 11:34 am
Running a RESTORE WITH VERIFY_ONLY, which is what the backup validation does, shouldn't interfere with log shipping or anything else on your server.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
January 8, 2015 at 7:31 pm
Thanks you
January 9, 2015 at 1:30 am
Grant Fritchey (1/7/2015)
Running a RESTORE WITH VERIFY_ONLY, which is what the backup validation does, shouldn't interfere with log shipping or anything else on your server.
It also won't verify that the backup's usable, unless the backup was taken with the CHECKSUM option.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 9, 2015 at 4:50 am
GilaMonster (1/9/2015)
Grant Fritchey (1/7/2015)
Running a RESTORE WITH VERIFY_ONLY, which is what the backup validation does, shouldn't interfere with log shipping or anything else on your server.It also won't verify that the backup's usable, unless the backup was taken with the CHECKSUM option.
And even then the only way to have 100% assurance is to run a restore.
But, it still won't hurt existing databases.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply