Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Backup Verification

By Thom Bolin,

The following script runs against the current server and retrieves number of days since last full or differential and the number of days between them. it also retrieves the number of hours since the last transaction log backup.
It currently returns a grid output.
currently the script is under going changes to send XML back to an email that SQL monitors and will be inserted into a dashboard type webpage.
By setting parameters for how long it should be between each type of backup tracked the dashboard turns the server red if the threshold is missed.

Total article views: 1219 | Views in the last 30 days: 7
 
Related Articles
FORUM

Find current record number in rdl

Find current record number in rdl

SCRIPT

Current Users, Session Counts & Authentication Type

The script gives you , the number of current users and their session counts and authentication metho...

FORUM

Missing numbers in a series

Missing Numbers

FORUM

Convert exponential Number to non-exponential numbers...

Convert exponential Number to non-exponential numbers...

FORUM

Number of current connections

hello i have a question, if i get the number of active spids by executing sp_who 'active', does thi...

Tags
 
Contribute