troubleshooting Question

SQL 2008 R2 master.mdf large file size (92GB)

Avatar of greentriangle
greentriangle asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
4 Comments3 Solutions274 ViewsLast Modified:
Hi,  
I have a SQL Server 2008 R2 system that is running out of space on the drive.  I have found a master.mdf file that is 92GB in size and I am assuming this is my issue.  I am hoping for some guidance on how we can reduce the file size of this.  I have located under the properties of this an option that is under automatic - Auto Shrink - is set to false.  What impact will this have if I alter this to true and how often and at what times would this run?
Also would there be any other options / command that I can run to reduce the size of this file.
I have limited experience with SQL so would really appreciated the help and guidance in trying to resolve this one.

Cheers,

Jason
SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros