6GB msdbdata.mdf

Hi all,

On my PC I noticed that my msdbdata.mdf file grew to over 6GB. I did sp_spaceused on each of the tables and they are all OK. I looked at the queues and they also seemed OK. I finally looked at the properties and seen that it cannot be shrink since it is 95 percent used.

Any ideas on how I can get it back to normal size?

Thanks

Avi

you may be knowing that msdb database is used SQL SERVER AGENT ( SQL Scheduller) by for all scheduled work in sql server instance. You backup history, DTS Versions, Job history related table may grow over a period of time and there by your MSDB Database can grow. check all these table and if not required delete the history.

Madhu

|||

Have you changed the amount of job history to keep in the SQL Agent? Do you have lots of DTS packages? Are the DTS packages setup to log there status to the SQL Server?

These things all take up space in the msdb database.

You can use the sp_dump_dtslog_all command to remove the DTS log information.

You can use the sys.destination_data_spaces command to remove SQL Agent Log Information.