We help IT Professionals succeed at work.

Will DBCC SHRINKDATABASE make transaction log grow

BartWestphal
BartWestphal asked
on
1,138 Views
Last Modified: 2012-05-05
We did a DBCC SHRINKDATABASE on SQL 2005 and the database was shrunk by 100 GB, but our transaction log grew by 26 GB (nearly doubled).  I don't know for a fact that these are related, but this is a test environment, and I don't know of any other things that could have accounted for such growth of the log.  My question is, does the transaction log grow or record data during a DBCC SHRINKDATABASE process?
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you both for the feedback.  Since both responses came within about one minute of the other, and both helped support what I needed to know - I split the points.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.