Clear the transaction log

Introduction

How To Clear A SQL Server Transaction Log

[Transaction Log full error]

DUMP TRANSACTION [database_name] WITH NO_LOG

- From the desktop of the machine having the problem, go to Start -> Program Files -> Microsoft SQL Server 6.5


- Launch ISQL_W

- A screen asking you to connect will appear. Fill in the name of the machine you are working on (for example, GEOCSCOLGRA and click Connect. If you have successfully connected a query window will appear.

- Open the drop down menu at the top of the query window. Highlight the name of the database that is having the problem (for example, csco_sideA)

- Type in the following statements. Put each statement on a separate line. Modify the text in bold (for example, change <database name="">to csco_sideA):
dbcc checktable (syslogs)
dump tran <database name="">with no_log
dbcc checktable (syslogs)
dbcc perflog