September 9, 2003 at 4:01 pm
Does anyone know of a SQL Server product that would let me do the following?
Connect to the instance
Configure thresholds like,
1.Show databases not backed up in the last X days
2. Show databases that are full rec. model that have logs not backed up in the last x days/hours.
3. Show jobs that have failed in the last x days.
I would then like to click a process button and have it bring back anything that is outside those thresholds?, any thing like that in a windows application?
September 9, 2003 at 5:04 pm
Nothing I know of, but shouldn't be too hard to script.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 9, 2003 at 5:07 pm
You may check 'backupset' table that contains a row for each backup set. This table is stored in the msdb database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply