Home / server / Questions / 26322
Accepted
Spence
Asked: 2009-06-16 19:12:40 +0800 CST

How do you switch an active SQL Server database into Simple Recovery Mode

  • 772

I've had some logging problems and based on the way the application works we don't need full recovery mode, which will help us with our logging.

How do I switch the database into simple recovery mode?

sql-server log-files

1 Answers

  1. Best Answer

    You can do it in SQL Managment Studio by right-clicking the database, choosing Properties, selecting Options in the menu on the left and changing the Recovery Model drop-down to Simple.

    In T-SQL the command is:

    ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE
    • 6