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

Transaction log full in sql server 2008 Expand / Collapse
Author
Message
Posted Sunday, July 20, 2014 6:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 20, 2014 6:46 PM
Points: 8, Visits: 18
I read the following artticle from MSDN for resolving transaction log issues if it becomes full.

I am a sql server newbie, so just posting to check if these steps , especially increasing disk space will work for sql server 2008

msdn.microsoft.com/en-us/library/ms175495.aspx
Post #1594430
Posted Monday, July 21, 2014 1:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 38, Visits: 148
Those will work..

http://msdn.microsoft.com/en-us/library/ms175495(v=sql.100).aspx

Btw, You can select which SQL Version you are using by selecting "Other Versions"

hth
Post #1594463
Posted Monday, July 21, 2014 1:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 4:10 AM
Points: 5,221, Visits: 5,119
Yep those steps will resolve the problem.

You will need to ask a few more questions now to the business to determine how to stop this from happening again, primarily around what is the recovery point objective (RPO), or how much data can we afford to loose before it costs the company.

That will then determine how to periodically generate a transaction log backup, to both comply with the RPO and also stops the log from getting out of control, (caveat large transactions can cause the log to grow abnormally so you will always need to keep an eye on its size).

I would also recommend this book for managing your transaction logs.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1594464
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse