Model database usage & recovery planning

Model database usage & recovery planning

 

  

Does anyone actually use the MODEL database? We have never used the
model database as framework of new databases. Change framework has all
new databases coming from DEV & QA before landing on PROD.

I cannot think of any reason, in our environment, why I would recover
the model database. So, if I discontinued backup of the database, what
is my recovery method if it become corrupt? Since mine is not used, can
I simply copy it from another server?


Thanks
--------------------------
Martin

MS Sql Server LazyDBA home page