Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: Recovery Mode is changing

    SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Recovery Mode is changing

    Originally posted by littleccguy
    SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.
    Just curious...does it make coffee for you too when you get in in the morning?

    Seriously doubt it...

    How many people have access to the box?

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    I

    I have to agree with Brett ! There has to be someone doing it. Or try running a Tace on MSDB for a week (you can select filters and options to keep the size to minimum)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •