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 Tuesday, April 2, 2013 8:44 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: Yesterday @ 5:08 AM
Points: 538, Visits: 2,069
why the system databases are in

master-simple
model-full
msdb-simple

Post #1437940
Posted Tuesday, April 2, 2013 9:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:37 AM
Points: 40,596, Visits: 37,053
Master because you can never restore log backups of the master database (it can't be restored WITH NORECOVERY)
Model set to whatever you want new databases to have, default is full, but that's just the default
MSDB is simple because it's the simplest option, set it to full if you need log backups of the jobs/job history, etc in there.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437981
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse