October 14, 2010 at 4:02 am
Hi ,
I have 3 sql instances (A,B,C) and there is database mirroring between A and B instances.
Now on A , i created a new database but i need it to mirror on C.
Now the question is can i created two endpoints on one instance?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 14, 2010 at 4:06 am
Yes mirroring is at database level . so you can create multiple endpoint within the same instance.
Cheers
SAT
Cheer Satish 🙂
October 15, 2010 at 9:37 am
You cannot create two Database Mirroring endpoints on the same instance. A simple test by trying to create a new mirroring endpoint on server A will show you:
Msg 7862, Level 16, State 1, Line 2
An endpoint of the requested type already exists. Only one endpoint of this type is supported. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
You can, however, have multiple mirroring partnerships through the same endpoints. So, if you create a new endpoint on C, you can mirror A and C through the existing endpoint on A and the new endpoint on C.
You would end up with:
A---B
C
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply