Home Forums SQL Server 2005 Backups Restore System DBs to Another SQL Instance RE: Restore System DBs to Another SQL Instance

  • One good practice for a DR is that any task should be able to be done by someone outside the team that normally looks after the service. This means the process for getting Exchange working should be planned and documented so that (say) a DBA can get Exchange working in a DR. Equally, is should be possible for (say) a SAN administrator to get SQL Server working. The whole point of an unplanned DR is that you should excpect reduced staff availability, either because they are a casualty or they cannot get to the DR site.

    Personally, I would look on a DR process that recovers SQL Server by restoring system DBs as a higher risk solution than a process that keeps the system DBs at the DR site up to date. It may be a pain to apply configuration changes to a primary and a DR site, but when a real DR happens it should be far easier to get SQL Server working.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara