SQL Server Performance

Error with SP1

Discussion in 'SQL Server 2005 Database Mirroring' started by Akthar, Sep 18, 2006.

  1. Akthar New Member

    Hi all,
    i have setup Database Mirroing in the following environment:
    Primary Server - SERVER A (SQL 2005 DEV edition)
    Mirror Server - SERVER B (SQL 2005 DEV edition)
    WITNESS SERVER - SERVER B (SQL EXPRESS)

    I have applied SP1 on all instances.

    The endpoints are created successfully but i got the following error when starting the mirroring

    "Alter Fail for database 'MirrorDB'



    AKTHAR
  2. satya Moderator

  3. Akthar New Member

    hello satya,

    thanks for the link, but it mention to disable the VIA option , it was already disable for me. does not resolve my problem

    any advice
    thanks

    AKTHAR
  4. Akthar New Member

    ok,

    i got the solution. you will need also to do a restore of the trans Log in Norecovery mode, which i was missing

    Thanks all


    AKTHAR

Share This Page