• [font="Verdana"]In high protection or high performance mode if the principal server is down then your mirror db will be in restoring state. Now inorder to make the mirror db as principal you need to connect to the mirror server and type the following command to perform manual failover,

    Alter database mirrordbname set partner force_service_allow_data_loss

    that will bring the mirror db online and you can work on it !

    hope this helps

    [font="Verdana"]- Deepak[/font]