Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, May 6, 2016 8:00 AM
Points: 174, Visits: 566

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, October 8, 2015 11:32 PM
Points: 1,132, Visits: 1,395
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:33 AM
Points: 8,186, Visits: 16,351
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