Discussion in 'SQL Server 2005 Database Mirroring' started by pcsql, May 4, 2009.
I just want to know the reasons why Database Mirroring cannot be used for system databases.
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.
Separate names with a comma.