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

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: Tuesday, August 5, 2014 8:59 AM
Points: 209, Visits: 567
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: Tuesday, August 5, 2014 8:59 AM
Points: 209, Visits: 567
Is shrinking of data file, or log file can affect performance ?
Post #1357164
Posted Tuesday, September 11, 2012 1:34 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 6,304, Visits: 13,598
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:58 PM
Points: 62, Visits: 568
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