MSDB Growing Weekly

Hello All.
We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
72.2 SCSI Hot Plug Server
We run over this server OLTP (3 databases), and OLAP (4 databases)
processes, the server performs okey but we have this issue:
Our MSDB grows about 150% weekly the only "solution" we have found is to
stop restart services in order to get MSDB small againg.
We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
get our OLAP solution updated, also a daily full backup is executed (to
disk) for all databases including master and msdb.
We have executed the following tip with no results.
[b]You can remove old backup and restore records from the MSDB database
by
running the sp_delete_backuphistory stored procedure, like this
USE msdb
EXEC sp_delete_backuphistory '01/01/00'[/b]
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
RegardsChristian,
Are the DTS packages updated often? These and their many versions are stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
"Christian A. Tello" <ctello@.oiecuador.com.ec> wrote in message
news:uZNZVJ%23GEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hello All.
> We have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD
> 72.2 SCSI Hot Plug Server
> We run over this server OLTP (3 databases), and OLAP (4 databases)
> processes, the server performs okey but we have this issue:
> Our MSDB grows about 150% weekly the only "solution" we have found is to
> stop restart services in order to get MSDB small againg.
> We execute on a daily basis arround 22 big DTS from AS400 (Jd Edwards) to
> get our OLAP solution updated, also a daily full backup is executed (to
> disk) for all databases including master and msdb.
> We have executed the following tip with no results.
> [b]You can remove old backup and restore records from the MSDB databas
e by
> running the sp_delete_backuphistory stored procedure, like this
> USE msdb
> EXEC sp_delete_backuphistory '01/01/00'[/b]
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>|||Thanks Chris
In fact we did that 8 or 9 weeks ago we deleted all versions. We modify
the certain DTS 4 times a month. At this time we have 94 rows within the
sysdtspackages table. We have 28 DTSs.
Any other ideas?
Thanks again
****************************************
Christian,
Are the DTS packages updated often? These and their many versions are
stored
in msdb. Look at sysdtspackages table. If you do not delete the previous
version and keep adding new versions this will fill msdb.
Chris Wood
Alberta Department of Energy
CANADA
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!