Avatar of goprasad
goprasad
 asked on

SQL 2008 DB Mirroring set-up

Hello experts,

I have built and set-up 3 x servers - to perform the role of Principal, Mirror and Witness servers.
Principal and Mirror servers has SQL 2008 installed and configured, Witness has SQL 2008 R2 Express edition.
Step 1: Installed and configured SQL 2008 in Principal server and restored application database.

Now how to go about setting up DB mirroring and test the possible synchronous/asynchronous options. IS there any step by step documentation available?

Please advise.

Thanks and Regards
Microsoft SQL Server 2008Windows Server 2008Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
MohammedU

8/22/2022 - Mon
Rahul Agarwal

goprasad

ASKER
Can I please have some more links on step by step with screenshots.
Thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
MohammedU

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.