Can't Shrink Transaction Log 79 GB

Question

Post reply

Can't Shrink Transaction Log 79 GB

Welsh Corgi

SSC Guru

Points: 116520
More actions
December 12, 2015 at 12:29 pm

#303169

I can't shrink a transaction log.
I have tried just about everything.
Any advice would be greatly appreciated.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63503 More actions · Answer 1

I would check Paul Randal's blog for some ideas. Maybe start here: Troubleshooting Transaction Log Growth[/url]

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 2

What is the log reuse description show for the database?

Any open transactions or records returned for: DBCC OPENTRAN() WITH TABLERESULTS

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Shawn Melton (12/12/2015)
What is the log reuse description show for the database?
Any open transactions or records returned for: DBCC OPENTRAN() WITH TABLERESULTS

No. I am the only one connected to the Database.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

pietlinden (12/12/2015)
I would check Paul Randal's blog for some ideas. Maybe start here: Troubleshooting Transaction Log Growth[/url]

I tried it but no success.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 5

Welsh Corgi (12/12/2015)
Shawn Melton (12/12/2015)
What is the log reuse description show for the database?
Any open transactions or records returned for: DBCC OPENTRAN() WITH TABLERESULTS
No. I am the only one connected to the Database.

What does the log reuse show?

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 6

Welsh Corgi (12/12/2015)
pietlinden (12/12/2015)
I would check Paul Randal's blog for some ideas. Maybe start here: Troubleshooting Transaction Log Growth[/url]
I tried it but no success.

Very specifically, what did you try from Paul's blog?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Continues here: http://www.sqlservercentral.com/Forums/Topic1744862-2799-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 8

take a full backup of the database then backup the transaction log then shrink the database.

http://www.sqlserverlogexplorer.com/shrink-transaction-file/[/url]