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

System database logging recovery models Expand / Collapse
Author
Message
Posted Monday, October 19, 2009 9:35 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 1,136, Visits: 690
Comments posted to this topic are about the item System database logging recovery models
Post #805402
Posted Tuesday, October 20, 2009 12:03 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 10, 2014 7:08 AM
Points: 3,448, Visits: 4,406
This behavior has been changed in MSSQL 2008 (see "model Database" in BOL 2008: http://msdn.microsoft.com/en-us/library/ms186388.aspx). Now the recovery model of 'model' database "depends on SQL Server edition".
Didn't find anything about this "dependency"
Post #805452
Posted Tuesday, October 20, 2009 4:57 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: Tuesday, September 06, 2011 8:17 AM
Points: 891, Visits: 22
In SQL Server 2008, the recovery model of the model database is now 'User Configurable'
http://msdn.microsoft.com/en-us/library/ms365937.aspx
Not had a chance to see a fresh install of SQL Server 2008, so no idea if it comes pre-configured with 'full' or with no model defined
Post #805587
Posted Tuesday, October 20, 2009 6:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 5,470, Visits: 23,487
jim.lawrence
Not had a chance to see a fresh install of SQL Server 2008


A fresh install of the Developer Edition - which is supposed to be identical to the Enerprise Edition the default is "Full". Other editions - I do not have installed at the present time


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #805634
Posted Tuesday, October 20, 2009 8:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 6:08 AM
Points: 1,076, Visits: 591
Nice one

What you don't know won't hurt you but what you know will make you plan to know better
Post #805740
Posted Tuesday, October 20, 2009 10:09 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 10, 2014 12:06 PM
Points: 540, Visits: 217
Fresh installs of SQL 2008 Developer and Standard have the model database set to Full.

Post #805874
Posted Tuesday, October 20, 2009 10:17 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: Tuesday, September 06, 2011 8:17 AM
Points: 891, Visits: 22
Cheers chaps. Worth knowing. All grist to the mill, and all that.
Post #805877
Posted Tuesday, October 20, 2009 5:56 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 5:10 PM
Points: 589, Visits: 2,436
The reason that it is "full" by default is because , if I understood well, the model database must always exist on a SQL Server system.
An other thing I learned, is that "If you modify the model database, all databases created afterward will inherit those changes" Neat!

This is what I like about those questions: learning! Nice question!
Post #806199
Posted Wednesday, October 21, 2009 4:51 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 1,052, Visits: 862
Model is the "model" for all user created databases. Stick anything in it - users, procs,tables etc and they will appear in all subsequent databases you create. Presumably if you change the recovery model that will carry through.


Post #806369
Posted Thursday, October 22, 2009 11:21 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 11, 2011 1:51 PM
Points: 341, Visits: 311
Tricky ... I guess it makes sense, and if I'd thought about it more, I would have answered correctly, but I just clicked "master" quickly without thinking.
Post #807345
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse