October 19, 2009 at 9:35 pm
Comments posted to this topic are about the item System database logging recovery models
October 20, 2009 at 12:03 am
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"
October 20, 2009 at 4:57 am
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
October 20, 2009 at 6:47 am
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
October 20, 2009 at 8:05 am
Nice one
October 20, 2009 at 10:09 am
Fresh installs of SQL 2008 Developer and Standard have the model database set to Full.
October 20, 2009 at 10:17 am
Cheers chaps. Worth knowing. All grist to the mill, and all that.
October 20, 2009 at 5:56 pm
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!
October 21, 2009 at 4:51 am
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.
October 22, 2009 at 11:21 am
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.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy