Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View Error The Log File for Database Res2SQL is Full

Category:Unassigned

Error The Log File for Database Res2SQL is Full

***The steps outlined in this article invovle using MS Sequel Server to do a database repair. These steps should be completed by your network or database administrator. ***



When apptempting to add a new reservation or modifiy an existing reservation (either in HWeb Agent or HWeb Dispatcher), you may get the following error:

10:39:24 ERROR      ** Error: The log file for database ‘Res2SQL’ is full. Back up the transaction log for the database to free up some log space.
 
This error is generated because the Transaction Log is full.

To clear the problem connect to the machine where MS Sequel Server is running and/or open the  the Enterprise Manager tool.

Make a backup of the main database (typically named Res2SQL in most Hudson installations) before proceeding any further.

After the backup has been made, right clicked on the original Database, and select Properties.

Go to the OPTIONS tab and change the Recovery Model from FULL to SIMPLE.

Press OK

Right click again on the original database, and select ALL TASKS, SHRINK DATABASE

Click OK.

Right click again on the original database, and select Properties.

Go back to the OPTIONS tab and change the Recovery Model from SIMPLE back to FULL.

Restart your HWeb Applications and the error should be cleared. If you have any further questions or do not wish to make these changes yourself, please contact Hudson’s Tech Support department.

Categories: