troubleshooting Question

why is my .mdf so big?

Avatar of scm0sml
scm0sml asked on
Microsoft SQL Server 2008
10 Comments2 Solutions426 ViewsLast Modified:
Hi,

I had a really large database had about 90 million records in.

I have got this down to 1 million records now but the .mdf is still 7.5gb.

Does that sound right for a db with a million records in?

If not what would be causing this size?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 10 Comments.
Join the Community
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 2 Answers and 10 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