Home Forums SQL Server 2005 Administering recovery model RE: recovery model

  • February 7, 2008 at 6:30 am

    #775977

    Erik Hansson (2/7/2008)

    Thanks for the answer but if you set the model database in simple mode can I change some of my user database to be in full mode and some still in simple mode?

    /ERIK

    Yes. Recovery mode is seperate for each database. The only time model database comes into play is when you setup a new user database with default settings.