Transaction log question

Question

Transaction log question

sunny.tjk

SSCertifiable

Points: 5041
More actions
April 16, 2012 at 12:16 pm

#254832

Can someone please tell me what needs to be my immediate action
(1) When the transaction log fills up(Recovery model is Simple)
(2) When the transaction log fills up(Recovery model is Full and log backups are taken regularly)

Viewing 3 posts - 1 through 2 (of 2 total)

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

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

Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

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

sunny.tjk SSCertifiable Points: 5041 More actions · Answer 2

GilaMonster (4/16/2012)
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Thanks Gail. Great article!