SQL Server Performance

Mirroring

Discussion in 'SQL Server 2005 Database Mirroring' started by lara99, Sep 5, 2008.

  1. lara99 New Member

    hi all i am planning to set up mirroring now,
    my concern is when i am done set up mirroring, lets say i want to do some maintainance on the parent
    server which can result in structural change of the database or tables, is there a way to do this without downtime
    my initial plan was to make the changes on primary and redirect all the apps to mirror but when the previous primary comes backup after maintainance as mirror i dont
    have a way to sychronize parent and mirror, as the new mirror have different structure .
    is there a workaround for this situation.

    please advise
  2. preethi Member

    From my undertsanding on database mirroring it is not possible to use mirroring for this.
  3. gurucb New Member

    No, I dont think this would be possible with mirroring. In Logshipping it may be possible, if and only if applications redirected to secondary server do read only operations. (by disabling all logshipping jobs on both servers) but do not commit data on secondary else log shipping may need to be reconfigured :).

Share This Page