DaveWentzel.com            All Things Data

Database Mirroring

 

Among the myriad of other uses, it's great to keep outages to a minimum (< 1 min) when:
  1. upgrading from 2005 --> 2008
    1. must be on at least 2005 SP2 Cumulative Update 5 to establish the mirror with 2008
  2. moving VLDB files to different SAN/volumes

One slight problem (in my opinion) with database mirroring...it operates only on the db level, not the server/instance level, so agent jobs and logins/orphaned users have to be handled appropriately. 

 
 

Add new comment