Solved

SQL 2008 DB Mirroring set-up

Posted on 2011-03-04
6
765 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:goprasad
  • 2
6 Comments
 
LVL 13

Expert Comment

by:agarwalrahul
ID: 35041585
0
 

Author Comment

by:goprasad
ID: 35087704
Can I please have some more links on step by step with screenshots.
Thanks
0
 
LVL 15

Expert Comment

by:MohammedU
ID: 35211566
0
 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
ID: 35211571
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question