>>All help is appreciated. Thank you.
>>
>>>>I am anticipating setting up mirroring between servers on opposite sides of the country. When I look at the BOL mirroring section, however, it says mirroring will not be continued in future SQL versions, and that AlwaysOn capability should be used. When I look at the instructions for AlwayOn, however, it seems that that is for a Windows cluster configuration. My servers are on different domains, and not in any cluster. So is Always on still a candidate, or would I need to go with mirroring, or even traditional replication?
>>>
>>>Hi, Rollin, I work more on the application side of SQL Server than hard-core administration, so I don't have a good answer at the moment. I will ask a few people and see what I can find out.
>
>Rollin,
>
>You best bet for a great answer would be if you ask in either
>
>
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads>
>or in the
>
>
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldisasterrecovery>
>forums.
Well, there are quite a number of links on MSDN about AlwaysOn vs Mirroring vs Replication. I was not able to find the first one I looked at, but they all seem to say the same type of thing. AlwaysOn is for clustered servers, Mirroring 'should' still be here for a while, but not forever, and replication still is good for DR as well.
Here is one of the links.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4ad086ae-6eab-44e3-b278-57120a5cace2/sql-2012-alwayson-vs-database-mirroring-vs-traditional-failover-clustering?forum=sqldisasterrecovery
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.