Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have two different Windows Sever 2008R2 instance located at different places such as db1 and db2. I need to make db2 as mirror server of db1 i.e. all the database on db1 will have a mirror copy on db2.

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.
If this question can be reworded to fit the rules in the help center, please edit the question.

1

Are the two instances on the same domain? Is name resolution working correctly between the instances?
–
mrdenny♦Jan 4 '12 at 17:51

2

You've confirmed that you can reach each database on the port (I.E., "telnet db1 1433" from db2 and "telnet db2 1433" from db1) - assuming you're using the default TCP ports?
–
KaneJan 5 '12 at 4:50

As, I have mentioned, they both are 2 diff Sql instances located on different servers all together. Such as one at 56.251.56.74 and second one at 74.85.655.85 (samples not the exact one)
–
user5543Jan 6 '12 at 5:26

have you tried all these suggestions from SQLAuthority ?
–
user5707Jan 10 '12 at 13:29