MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Angus Logan » SQL Script to clean up transaction logs on NON PRODUCTION servers

SQL Script to clean up transaction logs on NON PRODUCTION servers

7.13.2004 | 5:41 pm

When you are developing you are always constantly hitting your development databases thus blowing out the transaction log.

I have uploaded a script (http://www.thespoke.net/downloads/details.aspx?ArtifactID=41d12201-971e-47c3-b972-27a48b8bf229) that you can run on your DEVELOPMENT SQL Server(s) that truncates the Transaction logs.

On one of my development sql server's @ Data#3 the script free's up about 4gb on the hard drive.

Posted Oct 03 2004, 06:52 PM by anguslogan
Filed under: ,


Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems