Click here to Skip to main content
Click here to Skip to main content

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 -->

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


License

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

Share

About the Author

Fernando Finelli
Web Developer
Argentina Argentina
Lic. Fernando Finelli

Comments and Discussions

 
GeneralFor those of you with SQL Server 2000 PinmemberRichard Bywater14-May-02 23:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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.141216.1 | Last Updated 26 Apr 2002
Article Copyright 2002 by Fernando Finelli
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid