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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2009-04-24 : 07:48:19
|
| In my database server i have many databases (some unusing databases) the msdb database size is increasing, because of this i deleted unused databases and i run these procedure to get the free spaces These are the procedures EXEC msdb.dbo.sysmail_delete_mailitems_sp @sent_before = "datehere"EXEC msdb.dbo.sysmail_delete_log_sp @logged_before = "datehere"EXEC msdb.dbo.SP_PURGE_JOBHISTORY @oldest_date = "datehere" but i have not get any changes in the space of the databse i observer my databse space dail 04/15/09: size =17152.88 MBSpace available: 517.16MB04/17/09:size =17152.88 MBSpace available: 478.91 MB04/20/09: size = 17153.63 MBSpace available: 132.47 MB04/21/09size = 17153.63 MBSpace available: 115.16 MB04/24/09size = 23119.69 MBSpace available: 2095.52 MBtoday i observed my msdb database size is increased to 23119.69 MBand Space available: 2095.52 MB also increased why it is happened it suddenly please explain ?How to reduce the size of msdatabseplease explain it is urgent |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-25 : 07:51:10
|
| Monitor the tabke sizes and the log size.Just a snapshit of te table sizesmight give you a clue.A lot of systems hold unnecessay data in msdb which can cause this sort of problem - ssis packages and their logs is a common problem - move the logs to a user database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
how to reduce Msdb database size