SQL Server Performance

database mirroring testing

Discussion in 'SQL Server 2005 Database Mirroring' started by avipenina, Aug 18, 2007.

  1. avipenina New Member

    Hi,
    I've 2 SQL 2005 ENT on 2 Win2K3 and i'm testing DB mirroring and i've question.
    after i set that DB mirroring with no whiteness and i and i update the principal database with some tables and index and logins i stop the principal sql service "to imagine server failure" and i can't set the mirror database to operate his state is in Mirror,Disconnect / In Recovery. how i turn on the mirror database after my principal server crash?
    Thx
    avipenina, Aug 18, 2007
    #2

  2. satya Moderator

    So this is nothing but FORCED service, you could use ALTER DATABASE DBName SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS; because the mirror database is not changing, it could be a REDO queue issue. Look at BOL for FORCED SERVICE topic for more information.
    satya, Aug 19, 2007
    #3

Share This Page