June 29, 2015 at 6:17 pm
Comments posted to this topic are about the item DB Integrity & Backup Report
July 23, 2015 at 9:20 am
Nice script. However, I found one flaw to it. If you have a database that has never been backed up or had an integrity check run on it it will not show up in this report. I found this because I ran the report then created an empty db and reran it. The new DB will not show up until you run a database backup of it.
July 23, 2015 at 3:31 pm
Good One and thanks for sharing.
Thanks,
Naveen.
Every thought is a cause and every condition an effect
July 27, 2015 at 5:59 am
Hmm, thats a great find about db's without backups... I will modify the script and upload a new version! thx!
July 28, 2015 at 7:36 am
Thanks for the good script.
July 28, 2015 at 10:01 am
I do like simple status reports like this that are easily emailed, I send myself a summary of my nightly DBCCs and suspect pages. I look at half a dozen lines instead of 150k of results, as long as those half dozen lines are all zeroes.
Good job!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
August 10, 2015 at 5:00 am
Nice Nicholas!
I use similar queries to prioritize what is going to be done during my maintenance windows.
DBCC CHECK the DBs that haven't been done in a while or ever. Same goes for the restore testing.
I also setup a "Reporting" sql agent job to send me emails every morning (If needed). One of the steps
reports missing backups.
Thanks for sharing!
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy