65.9K
CodeProject is changing. Read more.
Home

Clear the transaction log

starIconstarIconstarIcon
emptyStarIcon
starIcon
emptyStarIcon

3.20/5 (9 votes)

Apr 25, 2002

viewsIcon

97630

dump 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 to csco_sideA):
dbcc checktable (syslogs)
dump tran with no_log
dbcc checktable (syslogs)
dbcc perflog