?
Solved

How to Configure a Database Mirroring with SQL Server 2005?

Posted on 2008-11-18
1
Medium Priority
?
2,810 Views
Last Modified: 2012-06-27
Dear Sir,

I have 2 identical servers running SQL Server 2005 Standard Edition Service Pack2.
On my First Server (Principal one) I have my current Live DB running now.
I need to configure a High Availability solution using Mirroring and Witness.
Please I need a step by step document with screen shot on how to configure all servers including the witness.

Thank you in advance,
0
Comment
Question by:ISC-IT-Admin
1 Comment
 
LVL 11

Accepted Solution

by:
f_o_o_k_y earned 2000 total points
ID: 22983388
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

864 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