Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Hamish 96 posts 154 karma points
    Mar 13, 2011 @ 06:19
    Hamish
    0

    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

    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

  • Hamish 96 posts 154 karma points
    Mar 13, 2011 @ 21:15
    Hamish
    0

    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:

    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.

Please Sign in or register to post replies

Write your reply to:

Draft