May 20, 2016 at 8:15 am
Afternoon All,
Is it possible to mirror a SQL SERVER 2014 (Enterprise) database to another server under a new name.
For example, I have a 3 node AlwaysOn group with a database called Poker - Synchronous and Auto Failover applied where appropriate and all so far is working fine.
What I would like is another Node, a 4th node with the same databases, async in this case but instead of being called Poker I want to call it PokerLive.
Then I wish to create a database snapshot from PokerLive called Poker.
Is this possible? The only reason for the 4th node is for this, so I don't want to build and add a test node in development if its all going to be naught and not possible.
Cheers All,
Alex
May 20, 2016 at 8:30 am
No, You cannot use a different name for same database since it is designed as a fail over technology.
May 21, 2016 at 7:32 pm
joeroshan (5/20/2016)
No, You cannot use a different name for same database since it is designed as a fail over technology.
+1
May 23, 2016 at 3:39 am
Thanks Both.
That is both a shame and annoying! Never mind... Drawing board beckons.
Cheers
Alex
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply