Can we setup mirroring with two different instance with a same server.

Question

Post reply

Can we setup mirroring with two different instance with a same server.

dsachu

SSCrazy

Points: 2242
More actions
February 24, 2012 at 6:35 pm

#391651

Hi,
Can we setup mirroring with two different instance with a same server.
Regards,
Sachin.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

IIRC, I believe the answer is yes. Each instance must listen on a different port, such 10234 and 10235.

dsachu SSCrazy Points: 2242 More actions · Answer 2

Hi,

Can also possible to set up the mirroring with single instance in a same server.

Regards,

Sachin.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Lynn Pettis

SSC Guru

Points: 442467

February 24, 2012 at 7:31 pm

#1451667

No.

dsachu SSCrazy Points: 2242 More actions · Answer 4

Actually i have one server with three instances....can possible to implement all the thing with my given scenarios (primary database, mirror database, witness).

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 5

Actually i have one server with three instances....can possible to implement all the thing with my given scenarios (primary database, mirror database, witness).

yes , u can

durai nagarajan SSCoach Points: 15778 More actions · Answer 6

dsachu (2/24/2012)
Hi,
Can also possible to set up the mirroring with single instance in a same server.
Regards,
Sachin.

mirroring is uses for more database availability time, if your first server crash second should be available for use. why does SQL should provide this feature.

Regards
Durai Nagarajan

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

satishm94 (2/26/2012)
Actually i have one server with three instances....can possible to implement all the thing with my given scenarios (primary database, mirror database, witness).
yes , u can

Yes, with multiple instances on one server you can setup mirroring but in a production environment it doesn't buy you anything.

The second question was can you do it with a single instance, and the answer to that is no.

venki83k Valued Member Points: 70 More actions · Answer 8

Hi,

please explain abt detail hw can i set in a single instance db mirroring if u possible send me with screen shots also

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

venki83k (5/21/2012)
Hi,
please explain abt detail hw can i set in a single instance db mirroring if u possible send me with screen shots also

You can't mirror a database to the same instance. If you are trying to mirror a database to the same server, you need two instances. This is fine for a proof of concept, or testing purposes but it buys you nothing really in a production environment.

venki83k Valued Member Points: 70 More actions · Answer 10

Through maintenance plan or jobs if there any chance ....

Ant-Green SSC Guru Points: 113507 More actions · Answer 11

venki83k (5/21/2012)
Through maintenance plan or jobs if there any chance ....

You CANNOT create mirroring on the same instance, it has to be different instances