Solved

Configuring SQL Server Mirroring - Can you do it with users connected?

Posted on 2013-01-10
2
200 Views
Last Modified: 2013-01-11
Hi
Can anyone tell me if it is possible / sensible to configure mirroring on an SQL Server 2008 R2 database while the users are using the database?

I have a number of databases that need to have mirroring turned on and have just been asked if I can do it during the day when the databases are in use.

I have looked and searched, but cannot find the answer so wondered if anyone here had any experience on this?

Many thanks
Sue
0
Comment
Question by:rdbconcepts
2 Comments
 
LVL 10

Accepted Solution

by:
ivanovn earned 500 total points
ID: 38763654
Looking at the documentation, there is no reason you couldn't do that. The steps include backing up the principal database and restoring it to a mirror and turning the mirroring on. For more information follow the steps outlined in the documentation:
http://technet.microsoft.com/en-us/library/ms188712%28v=sql.105%29.aspx
http://technet.microsoft.com/en-us/library/ms189047%28v=sql.105%29.aspx
0
 

Author Closing Comment

by:rdbconcepts
ID: 38767304
Thats great - thanks
Sue
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Group by and order by clause 28 46
GRANT, REVOKE, DENY 4 36
Job Dependencies in SQL Server Agent: 1 30
Stored Procedure 2 47
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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.
A short film showing how OnPage and Connectwise integration works.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now