Recovery Model using T-SQL

• ib_toddler

  Valued Member

  Points: 51

  More actions

  June 10, 2005 at 8:03 am

  #164844

  Is there a way to change a database's recovery model using T-SQL?

   

  Todd Stover

  
  Todd V. Stover

• Paul Cresham

  Hall of Fame

  Points: 3623

  More actions

  June 10, 2005 at 8:10 am

  #564614

  ALTER DATABASE database

  SET RECOVERY FULL | BULK_LOGGED | SIMPLE

  Also see BOL under ALTER DATABASE.

  HTH.