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: Yesterday @ 7:12 AM
Points: 134, Visits: 388

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: Sunday, September 7, 2014 10:22 PM
Points: 1,126, Visits: 1,387
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 @ 4:51 AM
Points: 6,350, Visits: 13,674
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