The transaction log for database 'staging' is full
I was developing a datatype that was deleting nodes and I accidentally stopped the localhost server as it was doing this. When I restarted and tried to log in to umbraco I got the following error:
The transaction log for database 'staging' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
I deceided to change the recovery model to a simple recovery model. I did this by running the following script:
ALTER DATABASE staging SET RECOVERY SIMPLE
After running the script, I was able to access the umbraco cms.
Is this the best solution? To be honest - not sure. Obviously before I start getting the site ready for running on a testing/live enviroment, this will need to be readdressed.
The transaction log for database 'staging' is full
I was developing a datatype that was deleting nodes and I accidentally stopped the localhost server as it was doing this. When I restarted and tried to log in to umbraco I got the following error:
There is an similar issue to http://forum.umbraco.org/yaf_postst9026_BIG-PROBLEM-Please-help-ASAP.aspx but the link that offers a script to resolve the issue is no longer active.
Anyone have any ideas on how to fix this (or an updated url of the script that i need to run that was mentioned in the above url)
Note: I'm currently hosting the database on a softsys server
After reading this article: http://plataan.typepad.com/microsoftdynamics/2007/01/how_to_stop_my_.html
I deceided to change the recovery model to a simple recovery model. I did this by running the following script:
After running the script, I was able to access the umbraco cms.
Is this the best solution? To be honest - not sure. Obviously before I start getting the site ready for running on a testing/live enviroment, this will need to be readdressed.
is working on a reply...