Truncate Transaction Log

Question

Post reply

Truncate Transaction Log

MyatSuu

SSC Veteran

Points: 292
More actions
April 7, 2004 at 3:46 am

#107482

Hello my friend,
I want to know how to truncate transaction log in SQL Server 2000. Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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

roberthamilton Ten Centuries Points: 1002 More actions · Answer 1

roberthamilton

Ten Centuries

Points: 1002

April 7, 2004 at 4:57 am

#501972

backup log with truncate_only

roberthamilton Ten Centuries Points: 1002 More actions · Answer 2

roberthamilton

Ten Centuries

Points: 1002

April 7, 2004 at 4:58 am

#501973

backup log database_name with truncate_only

MyatSuu SSC Veteran Points: 292 More actions · Answer 3

MyatSuu

SSC Veteran

Points: 292

April 7, 2004 at 5:07 am

#501976

Thank you so much for your help!

bellis SSCarpal Tunnel Points: 4667 More actions · Answer 4

Check out the links below:

FAQ: http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154

SQL 2000: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272318

SQL 7.0: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q256650

The last article from Microsoft has a "sample of how to create dummy transactions that wraps the log for a single logical log file and causes it to truncate". This did the trick for me.