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
This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.
A list of licenses authors might use can be found here
)
, don't blame me 
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Rant 
Admin