Database Options Changed but "OK" button grayed out

  • Hi all. On a development server, I have one database out of twenty causing me some grief. It's running SQL 2K, sp3. I know, it should be sp4 but I've only been on the job a little over a week. I'll get to it SOON, I promise. Anyway, this one database, when I go to Properties->Options and change the mode from "Simple" to "Full", the "OK" button remains grayed out. The only way around it is to change the sizing properties as well. This allows me to then save my changes as it un-grays the "OK" button. Again, it's only happening to one out of twenty databases on this particular server. Any thoughts (besides sp4) as to what is causing this or how to correct it without the sp?

    -- You can't be late until you show up.

  • Have you tried changing it via t-sql?

    Alter database mydatabasename

    set recovery full

    ¤ §unshine ¤

Viewing 2 posts - 1 through 1 (of 1 total)

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