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.
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'
If anyone have had this solved with a better solution instead of stopping
restarting services Ill be very gratefull at you.!!!
Regards
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
"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.
> 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'
>
> If anyone have had this solved with a better solution instead of stopping
> restarting services Ill be very gratefull at you.!!!
> Regards
>