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://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply