Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDF File size is growing fastly... Expand / Collapse
Author
Message
Posted Monday, July 28, 2014 5:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 2:56 AM
Points: 168, Visits: 538

Hi Experts....

I have a Problem like the Following ..

On 24th my Mdf size was 10GB,when i checked now the Mdf size was increased suddenly to 30GB.
Please give me some solution to decrease the Size and as well as where can i check the reasons behind that..


Awaiting for your valuable Response...

Regards
Chowdary...


Regards
Chowdary...
Post #1596780
Posted Monday, July 28, 2014 5:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
What kind of data are you storing in your MDF file? It may possible that fragmentation playing role here.
refer: http://msdn.microsoft.com/en-IN/library/ms188917.aspx


Thanks
Post #1596791
Posted Monday, July 28, 2014 6:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 6,763, Visits: 14,424
all replys here http://www.sqlservercentral.com/Forums/Topic1596764-1550-1.aspx#bm1596804

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1596805
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse