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

Data file Shrinking Expand / Collapse
Author
Message
Posted Tuesday, September 11, 2012 12:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 4, 2016 12:49 AM
Points: 246, Visits: 669
Hello Masters,

How the shrinking works? What happened when shrinking log file or DB file ? on my test db (whose actual size was 3400 MB), I went to shrink task and shrink log file and now db size is 610 MB!!

I shrink log file, than how db file shirnked ? Is it affecting any production?

In shrink action, second option is "Shrink File to" and than we have to feed some numeric value in MB, whats that factor is ? how that count is used to shrink a file?

Please if anyone can explain me it will be helpful for me to work on production.

thanks in advance.

Jitendra
Post #1357151
Posted Tuesday, September 11, 2012 1:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 4, 2016 12:49 AM
Points: 246, Visits: 669
Is shrinking of data file, or log file can affect performance ?
Post #1357164
Posted Tuesday, September 11, 2012 1:34 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 1, 2016 9:54 AM
Points: 8,318, Visits: 16,471
You'll find all the required info in Books Online here and here

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1357172
Posted Tuesday, September 11, 2012 1:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 14, 2015 8:49 AM
Points: 77, Visits: 689
Jitendra,

You might want to review this URL:

http://sqlserverpedia.com/wiki/Shrinking_Databases

It provides a good oversight to concerns when shrinking your database. Hope this helps.
Post #1357652
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse