> Does anyone actually use the MODEL database?

-- Yes. I have added a schema holding a number of utility functions, procedures and views to the model DB on each server I work with, so that these are immediately available when each new database is created.

> Change framework has all new databases coming from DEV & QA before landing on PROD.

-- But your developers may be using model.

> So, if I discontinued backup of the database, what is my recovery method if it become corrupt?

-- Make one last backup, and store it in a safe place. Then discontinue the backups. Make a new backup after installing each SQL Server service pack or patch, just in case it has modified the model database.


-----Original Message-----
From: Graves Martin D. [mailto:mssqldba-ezmlmshield-x35630090.[Email address protected]
Sent: Thursday, March 29, 2007 3:10 pm
To: LazyDBA Discussion
Subject: 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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page