msdbdata

Question

HI

please advice me how to msdbdata.mdf shrink SQL 2005

---

baskar R

Answer 1

Hi,

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)

Answer 2

Please follow this link to understand SHRINK.

---

-Vinay Pugalia
If a post answers your question, please click "Mark As Answer" on that post or "Vote as Helpful".
Web : Inkey Solutions
Blog : My Blog
Email : Vinay Pugalia

Answer 3

You can just shrink the msdb system database from SSMS Object Explorer:

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012