IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

AND EXISTS(SELECT 1 FROM sys.database_mirroring WHERE database_id = DB_ID('archer') AND

mirroring_role IS NULL)

BEGIN

use archer

SET NOCOUNT ON

END

Msg 954, Level 14, State 1, Line 6

The database "Archer" cannot be opened. It is acting as a mirror database.

:crazy: