View Error The Log File for Database Res2SQL is Full
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:
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.
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.