Click here to Skip to main content
12,560,241 members (53,016 online)
Click here to Skip to main content
Add your own
alternative version


14 bookmarked

Clear the transaction log

, 25 Apr 2002
Rate this:
Please Sign up or sign in to vote.
dump the transaction log
<!-- Add the rest of your HTML here -->


How To Clear A SQL Server Transaction Log

[Transaction Log full error]

- 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


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


About the Author

Fernando Finelli
Web Developer
Argentina Argentina
Lic. Fernando Finelli

You may also be interested in...


Comments and Discussions

GeneralFor those of you with SQL Server 2000 Pin
Richard Bywater14-May-02 22:17
memberRichard Bywater14-May-02 22:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.161026.1 | Last Updated 26 Apr 2002
Article Copyright 2002 by Fernando Finelli
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid