March 3, 2016 at 1:36 am
I am trying to configure mirroring in same instance for the database, not sure...It will be success. Please suggest , can it be possible to configure DB Mirroring in the same instance of sql server for single database....Thanks.
SQL Server 🙂
March 3, 2016 at 2:06 am
No, you need two separate instances.
BTW, why would you want to do that?
-- Gianluca Sartori
March 3, 2016 at 2:49 am
Thanks Sartori.....I just want to configure with my curiosity as don't have another instance in my machine and want to know the reason why its not been configure, Is that should be the same database name or any ?
Please clarify me .......:)
March 3, 2016 at 3:21 am
Here is everything you need to get started:
https://msdn.microsoft.com/en-us/library/ms190941.aspx
-- Gianluca Sartori
March 3, 2016 at 11:01 pm
You can set up two databases to be mirrored from the same server, but you can't mirror onto the same instance: http://www.sqlservercentral.com/Forums/Topic538887-1291-1.aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply