We help IT Professionals succeed at work.
Get Started

Unable to mirror a database in mode sync full

474 Views
Last Modified: 2012-05-11
Hello,

I'm trying to mirror a database which is hosted by a SQL Server 2008 R2 on another SQL Server 2008 R2 which is not in a domain. The database is set in full mode and I'm trying to mirror it on this new server but it returns an error at the end.

I've backup the database on the source server as well as the logs and imported them on the new server in NO RECOVERY mode.

The connection between the servers seems to be just fine, there isn't any firewall between them but I still got this error message after the wizard ends and I don't understand why :

*Alter Failed for Database 'Test'. An exception occured while executing a Transact-SQL statement or batch. The network address TCP://10.0.2.40:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational"

Any ideas ?
Kind Regards,
David

PS : There is no witness server. Is it mandatory to have one?
Comment
Watch Question
DB Expert/Architect
Top Expert 2011
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE