log file is full

Navi_Learner
Navi_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

  • kapamarou
    kapamarou Member Posts: 1,152
    Can you take a backup from SQL? This should flush the log file...
  • garak
    garak 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!
  • davmac1
    davmac1 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.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories