Saturday, August 18, 2012 5:26 AM
please advice me how to msdbdata.mdf shrink SQL 2005
Saturday, August 18, 2012 5:42 AM
MSDB database stores lot of log information
- Backup & Restore Log
- SQL agent history
- Database mail history
- DTS and SSIS package log
So, this can take lot of space is server if this has not been cleaned.
- Chintak (My Blog)
Saturday, August 18, 2012 6:45 AMPlease follow this link to understand SHRINK.
- Marked As Answer by Iric WenModerator Monday, August 27, 2012 9:21 AM
Saturday, September 22, 2012 11:28 AMModerator
You can just shrink the msdb system database from SSMS Object Explorer: