Hi LightVader,

Thanks for the answer for scenario-1. I got to know the same thing from my peers. We need to break the mirroring and bring it online.

use master

go

alter database <dbname> set partner off;

go

restore database <dbname> with recovery;

go