how do i truncate transaction log in sql server 2008

Question

Post reply

how do i truncate transaction log in sql server 2008

ashuthinks

SSCommitted

Points: 1698
More actions
October 18, 2011 at 7:35 am

#390642

hi,
please tell me how can i do this i'm newbie

Viewing 7 posts - 1 through 6 (of 6 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

It's generally a bad idea and the wrong solution to the wrong problem.

So aside from the obvious than the log is taking more place than you want to, what is the probem?

Do you have scheduled full and tlog backups?

ashuthinks SSCommitted Points: 1698 More actions · Answer 2

yes my transaction log gets full

so i need to take backup and truncate it

please give me sql script for that

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 3

Agree, not a good thing to do. Putting your DB into the full recovery model with both full & trans log backups should do the trick.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 4

http://msdn.microsoft.com/en-us/library/ms186865.aspx

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Take 30 minutes and read those 2 articles.

You'll understand exactly what's going on and how to fix it.

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 6

Ninja's_RGR'us (10/18/2011)
Take 30 minutes and read those 2 articles.
You'll understand exactly what's going on and how to fix it.
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Second vote for this.

Manage your log files, do not truncate them.