PowerDNN

Support Center

At PowerDNN, we know that communication is vital to any service.
Please feel free to contact us regardless of your needs.

 How to clear SQL transaction log.
Article

Log into the sql database (for more information see here:  http://support.powerdnn.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=64

Right click the database and click new query.

Type the following into the query:

Backup Log YOURDATABASEANME With Truncate_Only

replacing yourdatabasename with the name of your database.

After this you can right click the database and go to tasks -> shrink files to decrease file sizes.

You may also want to consider switching to simple backup to prevent the database from getting too large:

http://support.powerdnn.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=138



Article Details
Article ID: 225
Created On: 20 Dec 2009 5:58 PM

 This answer was helpful  This answer was not helpful

 Back
Theme by SupportSkins.com