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
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
actually not much to shrink- see the screenshot please
ASKER
screnshoot
SQL.bmp
SQL.bmp
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
Is it gonna do the same if I try to shrink the DB now?
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)
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)
ASKER
will try as soon as I can get to it, thank you
Sure and kindly don't ignore this question..
ASKER