Home Forums SQL Server 2008 SQL Server 2008 - General Database Mirroring Testing & Configuration RE: Database Mirroring Testing & Configuration

  • November 27, 2012 at 12:12 am

    #1562529

    shohelr2003 (11/27/2012)

    Dear,

    2. Now if I restore that backup files to Mirror, what would be that 1 hour updated transactions? Will I get those updated data after configuring mirroring?

    Yes, But this 'Sync' opeartion take time depending on the number of transactions to be processed. More the transaction, more the time to sync the mirror database.

    3. I want to get Principal Server down so that Mirror Server take the role just for testing purpose. Again I want that Principal Server will run and take the role from Mirror Server. Can you tell me how to get Principal Server down manually?

    1. You can initiate failover with Mirroring Wizard in ssms.

    2. Restart Principal Instance.

    Please help me to sort out the problem.

    Regards,

    Akbar