[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1106
  • Last Modified:

Will DBCC SHRINKDATABASE make transaction log grow

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?
0
BartWestphal
Asked:
BartWestphal
2 Solutions
 
SQL_SERVER_DBACommented:
Yes this is related, go ahead and truncate the transaction log, you log is recording the DBCC SHRINKDATABASE process.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
yes, DBCC SHRINKDATABASE will make your database log grow , you must truncate your log files after running this
0
 
BartWestphalAuthor 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.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now