Unfortunately, in that case you'll need to go through the failover process.

Wish you could specify the owner as part of the restore statement but no joy. Not sure if 'execute...

What if we do not know the password of the login "A"?

If we need to do modifications on mirror database, we must make it writable (set partner off + restore with recovery). But if the mirroring should be reset, we must...

If data loss happened when failed over to the mirror server, and there were lots of transactions happened on the mirror server during the downtime of principal server, HOW TO...

SELECT

FK_Table = FK.TABLE_NAME,

FK_Column = CU.COLUMN_NAME,

PK_Table = PK.TABLE_NAME,

PK_Column =...

you may use "having case ... end is not null"