Link to home
Start Free TrialLog in
Avatar of Anvie
Anvie

asked on

Implementing Database Mirroring

Hi,

Can anyone please tell me how to implement database mirroring step by step.

I have 2 servers
Server01 for production
Server02 for mirroring
Both server are configured the same.
   -- SQL 2005 64bit SP 2

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of KUMON2004
KUMON2004

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anvie
Anvie

ASKER

Thanks for the complete process.

I followed everything you said and it works fine until I click start mirroring. i got this error:

TCP//ServerName.DomainSegment:POrt connot be reached or not exist. is there a way to find this domain segment information. like Select @@ServerName or select @@version?

Thanks!
Avatar of Anvie

ASKER

Thanks again!