Caveat #1 - the first part of the query returns all records where the.Now let me explain those caveats, and this query. This data is then combined via the UNION statement to the second Last database (full) backup is older than 24 hours from the current systemĭate. That second statement returns information on allĭatabases that have no backup history. ![]() Tempdb out from the result set since you do not back up that systemĭatabase. The arbitrary value I've assigned to the aging value for databases without any backup It is recreated each time the SQL Server services are restarted. Using this final query I produce a report that is distributed to the DBA Team I've set that value at 9999 hours because in my environment I want to placeĪ higher emphasis on those databases that have never been backed up. On a daily basis that highlights any missed backups.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |