Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-12-01 : 10:31:20
|
| I just noticed that one of our production 2008 servers has Master set to "Simple" and Model set to "Full".Should Master be changed to full?Does Model really need to be full?ThanksQ |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-01 : 11:31:36
|
| Leave master simple. Changing it doesn't do anything anyway.See hereFor backwards compatibility with earlier versions of Microsoft SQL Server, the recovery model of master can be set to FULL or BULK_LOGGED. However, BACKUP LOG is not supported for master. Therefore, even if the recovery model of master is changed to full or bulk-logged, the database continues to operate as if it were using the simple recovery modelYou can change model if you wish. Model is just a template for new databases, so if you create a new database without specifying recovery model, it will by default take the recovery model of model.When I create new databases, I immediately set the recovery model to what I need it to be, so I don't really care what model is set to. |
 |
|
|
|
|
|
Master and Model Recovery Model