Click here to Skip to main content

Go to Tip/Trick

SQL-Server-2005

Clearing Transaction Logs

sx2008

Rate me:

5.00/5 (2 votes)

23 Jan 2011CPOL1 min read

7.4K

2

The root cause why the transaction log file grows so big is the wrong recovery model.The recovery model is set to full by default.99 percent of all SQL Servers never make use of this model because there is no backup of the transaction log file.So the great majority of all databases should...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Clearing Transaction Logs

4 Jan 2011thatraja

By this way tooHow to Shrink SQL Server database log files?[^]

SQL-Server-2005

2. Clearing Transaction Logs

24 Jan 2011Sunasara Imdadhusen

2 alternatives

Clear the transaction Log if you are facing a low disk space

SQL-Server-2005

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

sx2008

Software Developer (Senior)

Germany

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

Go to top