Developer forum

Forum » Development » The transaction log for database 'dynamicweb' is full.

The transaction log for database 'dynamicweb' is full.

E-mail notifications
Martin Nielsen
Reply
Posted on 26/07/2011 12:41:36

Hi,

When i try to loggin to the administration of a website i get this error.
What can i do about it? The solution is hosted by the client them selves.

----
INSERT INTO GeneralLog(LogAction, LogDescription, LogUserName, LogDate) VALUES (@LogAction, @LogDescription, @LogUserName, @LogDate)

The transaction log for database 'dynamicweb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
-----

// Martin


Replies

 
Jeppe Eriksson Agger Dynamicweb Employee
Jeppe Eriksson Agger
Posted on 26/07/2011 16:07:06
Reply

Hi Martin

What does the mentioned column 'log_reuse_wait_desc' contain?

This article might help you troubleshoot: http://support.microsoft.com/kb/317375

- Jeppe

 
Lars Hejgaard Sørensen
Posted on 01/08/2011 12:41:13
Reply
When your transaction log reaches its allocated size limit, you can either increase the limit or enable autogrowth. Autogrowth, however, will be fine until you're out of disc space, but then it's harder to deal with if you're not in a virtual environment. Both settings are accessible in Database properties -> Files. You may also be able to shrink the files by right clicking the database and choose Tasks -> Shrink -> Files or perhaps truncate the transaction log.

BR.
Lars

 

You must be logged in to post in the forum