• M A Srinivas (2/3/2011)


    Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master database every day .

    you would not do this every day. you only need to do it when you apply a patch to SQL, and then there would be an outage anyway. I would also copy the msdb,model and importantly the resource database. The master database is bought up to date by restoring the latest backup as described in the process. BTW SQL needs to be started in single user mode to restore the master database.

    This is a sensible addition to your DR strategy.

    ---------------------------------------------------------------------