log file is full

Navi_LearnerNavi_Learner Member Posts: 356
edited 2008-12-04 in SQL General
Hi, Urgent! Our log file is full and we canot access the Navision. Help!!!

Comments

  • kapamaroukapamarou Member Posts: 1,152
    Can you take a backup from SQL? This should flush the log file...
  • garakgarak Member Posts: 3,263
    viewtopic.php?f=33&t=29694

    also seach the Forum for "Log file" or transactionLog or Recovery Mode AND Simply


    Regards
    Do you make it right, it works too!
  • davmac1davmac1 Member Posts: 1,283
    If all else fails, you can truncate the log file.
    To be safe, get everyone out of the system. If you can, backup the database using SQL Server backup. Then truncate the log file and shrink the file.
    After that, backup the log file regularly so it does not keep growing.
  • krikikriki Member, Moderator Posts: 9,115
    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.