SQL server 2005 error id 8309

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Wesly Tan
    #1

    SQL server 2005 error id 8309

    Microsoft SQL 2005

    Event id: 8309

    Event Description:
    BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.

    Problem:
    After changed all database recovery mode to simple, restart the SQL server, restart SQL server agent, changed user permission, the error 8309 still occur, please advice, thanks..
    Tags: None
    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878
      #2
      Here, read this...


      Good Luck!!!

      ~~ CK

        Comment

        • Wesly Tan
          #3
          Tried, still the same

            Comment

            • NeoPa
              Recognized Expert Moderator MVP
              • Oct 2006
              • 32636
              #4
              Originally posted by Wesley
              Wesley:
              Tried, still the same
              Give us a clue what you tried. I read the linked article and I can say it's not so simple that your response makes any sense. Did you try the bit where the author says "I don't recommend this. It's just for illustration."?

              Please post something that makes sense and shows you've actually attempted to do something before requesting more help.

                Comment

                Previous template Next
                Working...