Click here to Skip to main content
15,888,351 members
Articles / Database Development / SQL Server

Clearing Transaction Logs

Rate me:
Please Sign up or sign in to vote.
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...

Views

Daily Counts

License

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


Written By
Software Developer (Senior)
Germany 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