SQL Server Performance

SQL Mirroring question

Discussion in 'SQL Server 2005 General DBA Questions' started by tarekj, Nov 12, 2012.

  1. tarekj Member

    hi,

    I'm planning to make mirroring to my SQL Server, but I have two questions:

    1- My DB is involved in replication, so my question is the mirrored database will have the same data and when it comes up, the distribution database will have the current replicated records? are there any extra steps should I take to configure the mirror for a replicated database?

    2- When the server is down I will use the mirrored server, but this will affect my application as it calls the main server my name, so I have to change the server name for each client, is there a better idea?

    Thanks
  2. Luis Martin Moderator

    Kindly don't duplicate posts.
  3. tarekj Member

    Hi Luis,

    I don't like to duplicate posts, but after I post it I saw the words [Forum Closed] so I thought I had to post it in different forum.

Share This Page