Will DBCC SHRINKDATABASE make transaction log grow

Posted on 2007-10-12
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?
Question by:BartWestphal
    LVL 16

    Accepted Solution

    Yes this is related, go ahead and truncate the transaction log, you log is recording the DBCC SHRINKDATABASE process.
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    yes, DBCC SHRINKDATABASE will make your database log grow , you must truncate your log files after running this

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now