Change from Full Recovery to Simple Recovery Mode?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ttcdr
    New Member
    • Sep 2007
    • 2

    Change from Full Recovery to Simple Recovery Mode?

    We have MS SQL 2000 server, the log file of our Database growth to 23G.

    If I change the database from Full Recovery mode to Simple Mode, the log file should shink. Am I correct???


    And how do I do that? Am I just:
    Enterprise Manager --> right click the database --> properties --> Change the recovery from "Full" to "Simple"???

    Thanks a lot
Working...