473,239 Members | 1,417 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,239 software developers and data experts.

SQL 2K Backup Log Monitoring

Greetings,

I'm looking for a little guidance. I work for a medium sized bank
with about 20 SQL servers in 2 locations. We have two backup schemes -
Less critical SQL boxes have nightly DB backups and Transaction Log
dumps, more critical boxes have additional hourly transaction dumps.
The database maintenance should be deleting any backups more than 2
days old (Should have been picked up by system backups and moved to SAN
by then).

My question: Sometimes the SQL backups fail, usually for lack of
disk space. As it stands now it's a tedious process of reviewing the
logs of each of the 20 servers to check for failure. Is there a product
that can centralize these logs or give meaningful errors on failure?

I'm not real keen on using the email/pager reporting function from
the DB Maintenance. We have 4 techs who rotate on reviewing the logs
and we don't want to receive unnecessary emails 75% of the time or have
to change the account info every week.

Any suggestions would be appreciated.

Thank,

Jim

Jul 23 '05 #1
1 1536
Ray
SQLMaint which is what the maintenance wizard is configuring jobs for and
running is a bit cautious or wasteful depending on how you look at it. It
will create the latest backup before deleting the old one so during the
backup the server consumes more disk than expected. Most DBAs end up
writing a set of scripts to maintain the health of their databases. As for
SQL mail, I don't particularly care for it either. In SQL 2005 there will
be an smtp sender that you can use to replace most of what SQL mail does.
Until then try building a command line or batch file and using xp_cmdshell
with a freeware smtp product like BLAT. With multiple servers to monitor
and maintain, write flexible scripts and pool the alerts to one server and
alert from there.

There may be products on the market for many of these tasks, but with a
little creativity everything you need is there.

Good luck.

"Oddsavant" <Ji**********@unionfedbank.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Greetings,

I'm looking for a little guidance. I work for a medium sized bank
with about 20 SQL servers in 2 locations. We have two backup schemes -
Less critical SQL boxes have nightly DB backups and Transaction Log
dumps, more critical boxes have additional hourly transaction dumps.
The database maintenance should be deleting any backups more than 2
days old (Should have been picked up by system backups and moved to SAN
by then).

My question: Sometimes the SQL backups fail, usually for lack of
disk space. As it stands now it's a tedious process of reviewing the
logs of each of the 20 servers to check for failure. Is there a product
that can centralize these logs or give meaningful errors on failure?

I'm not real keen on using the email/pager reporting function from
the DB Maintenance. We have 4 techs who rotate on reviewing the logs
and we don't want to receive unnecessary emails 75% of the time or have
to change the account info every week.

Any suggestions would be appreciated.

Thank,

Jim

Jul 23 '05 #2

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

Similar topics

1
by: Ron | last post by:
I am trying to run asp.net pages. The server is accessed via http://sitename/username I have verified it is using port 80 and aspx extensions are configured. But when I run and asp.net page I...
4
by: ikosianski | last post by:
Hallo, MSDB.dbo.BackupSet logs all backups is it possible find Status of Backup (Success / Failed)? Table "BackupSet" hasn't any information about it. I need log and notify all backups with...
4
by: Erik Hendrix | last post by:
Hi, I have a quick question, when one sets the prefetch size = extent size, then when doing a backup we will have 1 agent (db2bm) doing the reads. If we have prefetch size a multiple of extent...
3
by: datapro01 | last post by:
I 'm working with a company that decided to install a new dbms and environment (DB2 on AIX). Most of the talent here is mainframe oriented. When the deision was made as to which distributed...
4
by: johnm | last post by:
Hello, We currently are running a CRM application that uses DB/2 7.2 for the data repository. We will be upgrading to 8.2 later this year....maybe....time and resources permitting. The...
9
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
1
by: bwmiller16 | last post by:
Folks - DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and...
0
by: myearwood | last post by:
Hello I'm working on a project which involves ordering SQL Server 2000 and up to begin a backup via SPT. BACKUP DATABASE myDB TO DISK = 'myfile.bak' I'm using an asynchronous connection. I'd...
2
by: krx | last post by:
Hello, Is there a way in DB2 or maybe a separate tool that will let us see how many pages DB2 has currently read while a backup operation is in progress. I understand "db2 list utilities show...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
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...

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.