SQL 2005 MSDBDATA databse size

My msdbdata file has grown to 450MB and taking a lot of space on C drive. How can I a) reduce it's size or 2) can I move it to the D drive with other system DBs?

Thank you
LVL 1
piotrmikula108Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Seems like you have accumulated huge no. of logs in your msdb database for your agent jobs, maintenance plans..
Its time to delete your older logs or backup history in order to claim free space in your msdb database.

http://www.aspdeveloper.net/tiki-index.php?page=SqlCleanupLargeMSDB

PS: I can provide you the steps to move msdb to D drive if required but having huge msdb database file size would impact your performances of backups, agent jobs, maintenance plans at some point of time..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
piotrmikula108Author Commented:
thank you, so shrinking the DB would be the first step to take, right?
0
piotrmikula108Author Commented:
actually not much to shrink- see the screenshot please
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

piotrmikula108Author Commented:
screnshoot
SQL.bmp
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Try creating a History Cleanup task and remove history information of your

* SQL Agent Jobs
* Maintenance Plans
* Backup jobs

which should reduce your msdb file size and then try the shrinking approach.

MSDB Data size would be huge if you have any one of the following available:

* Several Maintenance plans
* SSIS Packages.
0
piotrmikula108Author Commented:
I created the History Clean up maintenance task for the MSDB and it almost killed my server as the msdblog.ldf file filled up :-)

Is it gonna do the same if I try to shrink the DB now?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Ok, to shrink your LDF file follow the steps mentioned in "Moving the MSDB database" in the link below:

http://support.microsoft.com/kb/224071

* To be in the safer side, take a full backup of msdb database.
* First detach your msdb database.
* Attach you msdb database without providing ldf file ( which would by default create a new ldf file)
0
piotrmikula108Author Commented:
will try as soon as I can get to it, thank you
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Sure and kindly don't ignore this question..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.