Support Center » Knowledgebase » How to clear your SQL Server transaction logs
 How to clear your SQL Server transaction logs
Solution

The transaction logs are backed up and cleared daily. Though the control panel only shows the highest size the transaction log has reached in previous days.

You can manually increase the database size and transaction log file size from within the control panel. The following link will help you increase the sizes.

http://www.drundo.info/doc/hsphere/html/mssql_support.html#quota

If you are receiving errors that your transaction logs are full or your Primary Filegroup is full
(which may not actually mean your database is full), then log into your database with SQL Server Management Studio, and run this script to clear your transaction logs:

DUMP TRANSACTION [database_name] WITH NO_LOG

In case your current database user does not have DBO permissions please submit a DBO permission request at:

http://drundo.info/index.php?_m=tickets&_a=submit&step=1&departmentid=31



Article Details
Article ID: 150
Created On: 20 Feb 2008 01:24 AM

 Search
 Article Options