[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2013-01-10
2
Medium Priority
?
210 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
ivanovn earned 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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