SQL Server Product

[Sevo]

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 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?

[Greg D. Moore \(Strider\)]

Re: SQL Server Product


"Sevo" <swiedner@comca st.net> wrote in message
news:UpCdnWAL8u f6PsKiXTWJkw@co mcast.com...[color=blue]
> Does anyone know of a SQL Server product that would let me do the[/color]
following?

Not offhand, but...

You can write a query that does that with a little effort:

Something like

select database_name, backup_set_id, type, backup_size from msdb..backupset
where backup_start_da te> getdate()-5

Will show you the databases and types of backups for the last 5 days.

Obviously you'll want to set the day threshold to your needs.

Combine this with a join that looks against master..sysdata bases and you can
probably return the names of databases that exist, that don't have full or
log backups.

If you want, send this via xp_sendmail (or other mail utility of your
choice) or get fancy and use a webtask and create a webpage that shows you
the current output.

(Gah, now you've got me thinking about doing this for work...)

It's pretty straight forward I'd think.

[color=blue]
>
> Connect to the instance
> Configure thresholds like,
> 1.Show databases not backed up in the last X days
> 2. Show databases that are full that have logs not backed up in the[/color]
last[color=blue]
> 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[/color]
anything[color=blue]
> that is outside those thresholds?, any thing like that in a windows
> application?
>
>[/color]