Sign in Register
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

    Copy Link
  • 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.

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies