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?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
piotrmikula108Author Commented:
screnshoot
SQL.bmp
0
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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 & ArchitectCommented:
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 & ArchitectCommented:
Sure and kindly don't ignore this question..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.