Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

recovery model Expand / Collapse
Author
Message
Posted Thursday, February 7, 2008 4:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:13 AM
Points: 21, Visits: 231
Are you allowed to set a user database in full recovery model if the model database is in simple mode?
ERIK
Post #452653
Posted Thursday, February 7, 2008 6:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
MODEL database is used for Templet.

When the user will create the new database it will use the templet of MODEL database to create new database and all setting will be inherited to new database.

Hence when user will create database if you wish to have all your new database in Full Recovery mode; You need to put the MODEL database into full recovery mode else after the creating database user have to set full recovery.

No harm in putting MODEL database in Full recovery mode.



---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #452684
Posted Thursday, February 7, 2008 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:13 AM
Points: 21, Visits: 231
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
Post #452691
Posted Thursday, February 7, 2008 6:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:31 AM
Points: 999, Visits: 13,473
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.
Post #452694
Posted Thursday, February 7, 2008 6:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 8:13 AM
Points: 21, Visits: 231
OK Thank you!

/ERIK
Post #452709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse