View Error The Log File for Database Res2SQL is Full
Error The Log File for Database Res2SQL is Full
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:
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.
Right click again on the original database, and select ALL TASKS, SHRINK DATABASE
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.