473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL Server Product

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?
Jul 20 '05 #1
1 1505

"Sevo" <sw******@comcast.net> wrote in message
news:Up********************@comcast.com...
Does anyone know of a SQL Server product that would let me do the 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_date> 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..sysdatabases 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.


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?

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: V. Jenks | last post by:
What seems like a simple thing is apparently not so straightforward? I have a datalist. Inside of that datalist is an <itemtemplate> secion which contains other server controls such as a...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
1
by: kataoki | last post by:
Hi, This is the log file for my SP1 on 2005 install. Can anyone please look at this and tell me if this looks normal? I'm concerned about the following in the log: "Failed to read registry...
6
by: Jean-Marc Blaise | last post by:
Hi, I have installed DB2 9.5 directly from FP1 on Windows in custom mode with COMP=CONNECT_SUPPORT. I then added my DB2 Server license. I am surprise that db2licm refers to a DB2 Connect...
3
by: graphicssl | last post by:
Okay, so first of all, I'm a designer first and a light coder second (I'm only really trained with HTML and CSS). So I apologize for having to post about something that's probably super-trivial! ...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.