MS SQL Server 2012 - How to reduce MSDBData.mdf file
Posted on 2014-01-22
Hello from Italy,
we're running MS SQL Server 2012 under 2008 R2
(under VMware ESXi 5.1)
The unique database is the ERP database
(the size of ERP database is 28 GB)
We make the database backup two times at day
(The VM is fully backed-up every night)
We found MSDBData.mdf file is 32 GB !!!
1) MSDBData.mdf size may be correct?
2) How can we limit the MSDBData.mdf size?
(Can we modify some standard settings?)
Thank you very much for your worldwide help!