Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cteloman
Starting Member
1 Post |
 Posted - 2004-04-06 : 10:16:22
|
| Hello SQLTeam GuysWe have a problem with our SQL Server it is a 4 processor 2 Gb RAM, 8 HD 72.2 SCSI Hot Plug ServerWe 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 msdbEXEC sp_delete_backuphistory '01/01/00'If anyone have had this solved with a better solution instead of stopping restarting services I´ll be very gratefull at you.!!!RegardsChristian A. TelloIT Manager CridesaGuayaquil-EcuadorPhone: 593 9 8478027 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-06 : 12:29:16
|
| Your DTS packages must be logging information. sp_delete_backuphistory is not for deleting logging information. It is to delete backup history information.You should modify your DTS packages so that they do not log so much information. Do you have space issues on your server?Tara |
 |
|
|
|
|
|
MSDB Growing Weekly