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