Solved

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

Posted on 2013-01-10
2
201 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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