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: Monday, October 20, 2014 6:48 PM
Points: 1,136, Visits: 699
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: Friday, May 9, 2014 12:47 AM
Points: 3,448, Visits: 4,407
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 6, 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: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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: 2 days ago @ 12:21 AM
Points: 1,083, Visits: 594
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, October 23, 2014 7:45 AM
Points: 540, Visits: 232
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 6, 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: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
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: Tuesday, November 11, 2014 2:51 AM
Points: 1,070, Visits: 912
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