Tag Info

New answers tagged

1

Applications do their testing against the new principal which is ServerB but don't want to take those changes or sync to ServerA (Mirror). Is there any way to do this without breaking the mirror? No this is not possible to prevent changes to ServerA. You have to resetup mirroring from original primary ServerA to ServerB What you can do is : ...


0

This should work as it did for me: Set the -failoverpartner using the mirror name in the sql agents for replication. Fail mirror over to secondary Make sure replication continues to send commands to subscriber. Remove mirroring so primary is no longer connected. Go to distributor, add an alias (sql server alias) The alias should be the old principal name ...


0

To remove database mirroring Connect to the Database Engine of either mirroring partner. From the Standard bar, click New Query. Issue the following Transact-SQL statement: ALTER DATABASE database_name SET PARTNER OFF where database_name is the mirrored database whose session you want to remove. The following example removes database mirroring from the ...



Top 50 recent answers are included