August 20, 2018 at 7:59 am
Hello
I got a question regarding to the integrity checks of the database.
Is there a book that talks specifically about the importance of integrity checks that you should apply to VLDB or any database?. I have been searching at amazon but nothing comes up.
Its some kind book that explains the DBCC commands in depth, ways to implement it to check for integrity consistency at the database level, or if you can recommend a book that the main focus is integrity checks.
Some techniques, recommendations or advice from the professionals regarding the importance of it, while i was reading another post What does your backup process look like? i saw the pros of the forums at one point talking about the integrity checks before or after backups. Now i didn't wanted to ask questions about the subject there because the post wasn't about Integrity checks but about your backup process.
I read something that Gail posted that i didn't knew and i quote.
Mike Scalise -
So, are you saying that I would run DBCC with physical_only on my database on the secondary server, then back up the database, then restore it to the non-production instance of SQL Server, THEN do a comprehensive DBCC on that non-production instance?GilaMonster -
NO!
The only thing that tells you is that the secondary is intact. It tells you nothing at all about the primary (which is probably the DB you care about the most)
You know these important points that aren't in the documentation but really experienced people know.
Thanks for your time reading this post.
Have a great week.
August 20, 2018 at 8:07 am
Alejandro Santana - Monday, August 20, 2018 7:59 AMHelloI got a question regarding to the integrity checks of the database.
Is there a book that talks specifically about the importance of integrity checks that you should apply to VLDB or any database?. I have been searching at amazon but nothing comes up.
Its some kind book that explains the DBCC commands in depth, ways to implement it to check for integrity consistency at the database level, or if you can recommend a book that the main focus is integrity checks.
Some techniques, recommendations or advice from the professionals regarding the importance of it, while i was reading another post What does your backup process look like? i saw the pros of the forums at one point talking about the integrity checks before or after backups. Now i didn't wanted to ask questions about the subject there because the post wasn't about Integrity checks but about your backup process.
Thanks for your time reading this post.
Have a great week.
I don't know of any books but there are a lot of articles on about dbcc checkdb on sqlskills.com. Paul Randal used to work for MS and wrote a lot of the dbcc checkdb code:
Checkdb from Every Angle
Sue
August 20, 2018 at 8:47 am
100% agree with Sue, Paul is the best when it comes to deciphering CheckDBs. If you are concerned about VLDBs, these two specific articles might be helpful:
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2006/10/19/checkdb-part-6-consistency-checking-options-for-a-vldb/
https://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-consistency-checking-options-for-a-vldb/
August 20, 2018 at 9:42 am
Thank you so much for the feedbacks Sue_H and Sreekanth B.
I'll be spending the next days reading and reading these articles.
Really appreciate.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply