Depends on what is causing the problem.  If it's one GIANT DB that is
causing the problem, this may not help.

But if the db's aren't too big, I've had good luck turning over the
backups to  SQL Enterprise Manager.  It's very easy to set up local
backups to disk.  You tell it to keep a minimum number of generations, say
2-3.

It creates flat file copies in the SQL /backups directory.
Then you let TSM back up the flat files.  When SQL purges the older
generations from the /backups directory, TSM still has a copy because the
filenames are unique.

If you need to restore a recent generation the DBA just uses the SQL
tools. If you need to restore an older generation, you restore the flat
file using TSM, then the DBA can use the SQL tool again.

You can also have the Enterprise manager back up different data bases on
different schedules.  Unimportant ones could be backed up every other day,
for example, to reduce the load.

You could also turn on COMPRESSION in the TSM backup client to reduce the
amount of data you have to transmit; in that case make sure you run your
backups of the flat files during a least-busy time for SQL, because it
takes more CPU to compress.

If the problem is that SQL is slow getting the backups done, this might
work better than what you are doing now.

W





> Good morning!
>
> Does anyone have a good solution for remote backup clients that have
> database files on them?  We are struggling with getting backups on these
> remote servers when they have SQL databases on them.  If we let them run
> too long in the attempt to get a backup, they eventualy pin the log on the
> TSM server and we risk the server crashing.
>
> Any ideas on how to accomplish this task would be greatly appreciated!
>
> Thanks!
> ------------------------------------------
> Medtronic
> Collins, Brenda
> Sr. Principle Systems Admin
> brenda.s.collins AT medtronic DOT com<mailto:brenda.s.collins AT medtronic 
> DOT com>
> tel: 763-514-4969
> mobile: 763-218-9596
> ------------------------------------------
> Always have my latest
> info<https://www.plaxo.com/add_me?u=60130810166&v0=1860631&k0=2093372666&src=client_sig_212_1_card_join&invite=1>
> Want a signature like this?
> <http://www.plaxo.com/signature?src=client_sig_212_1_card_sig>
>
>
> ___________________________________________________________________________________________________
> CONFIDENTIALITY AND PRIVACY NOTICE
> Information transmitted by this email is proprietary to Medtronic and is
> intended for use only by the individual or entity to which it is
> addressed, and may contain information that is private, privileged,
> confidential or exempt from disclosure under applicable law. If you are
> not the intended recipient or it appears that this mail has been forwarded
> to you without proper authority, you are notified that any use or
> dissemination of this information in any manner is strictly prohibited. In
> such cases, please delete this mail from your records.
>
> To view this notice in other languages you can either select the following
> link or manually copy and paste the link into the address bar of a web
> browser: http://emaildisclaimer.medtronic.com
>