Post reply

i get an error when i try to insert data ino tables

  • March 8, 2011 at 8:25 am

    #144899

    hi all

    i get this error message when i insert data into tables

    Message: The transaction log for database 'rxhope' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

    thank you all for looking into it

  • March 8, 2011 at 8:27 am

    #1295912

    Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 8, 2011 at 9:24 am

    #1295962

    thanks a all, i did shrink the log files and it worked for now.

  • March 8, 2011 at 9:34 am

    #1295970

    If the log grew, shrinking isn't necessarily the solution. It fixes things, but please read Gail's (GilaMonster) article and make sure you have full backup set up.

  • March 8, 2011 at 9:38 am

    #1295976

    yes my next move is to fallow Gail Shaw, thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply