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
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 .
