SQL Server Performance

What are the reasons why Database Mirroring cannot be used for system databases?

Discussion in 'SQL Server 2005 Database Mirroring' started by pcsql, May 4, 2009.

  1. pcsql New Member

    I just want to know the reasons why Database Mirroring cannot be used for system databases.
  2. techbabu303 New Member

    A mirrored database is not available for access , since it is in "recovering" state which implies that system databases can not be mirrored and is not intended as the replacement for replication).
    You can, however, get around this limitation by creating a database snapshot of the mirror and use it instead. It is also not possible to create separate mirrors of the same database.
    http://www.databasejournal.com/feat...ability-Enhancements---Database-Mirroring.htm
    -Sat

Share This Page