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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2009-10-15 : 23:06:35
|
| Can anyone tell me what is the RECOVERY MODEL for MODEL database?Is it necessary to have Recovery Model to be as FULL?If so, What are the implications?Please Clarify? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-10-16 : 01:52:57
|
| Recovery model for Model database is by default FULLNecessary or Not, it totally depends upon simple question that How transactions will be logged, whether the transaction log will be backed up, and what restore options you will adopt in future for your database?Specially when you need POINT IN TIME RECOVERY you must set your database recovery model to FULL. But when it comes to Bulk Data Insert, you must switch to Bulk-Logged recovery model,and if you think that there is no need to log your transactions and you can depend upon your FULL DATABASE BACKUPS, keep trust in SIMPLE recovery model. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-16 : 03:07:45
|
| Note that whatever recovery model Model has will be the same recovery model that all new databases on that instance have.--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2009-10-21 : 23:43:11
|
| Thanks all.Other User databases still have the different recovery model while MODEL is FULL. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-22 : 05:07:04
|
| Yes, they can, but any NEW database that you create on that server will have the same recovery model as the Model database.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
System DB