?
Solved

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

Posted on 2013-01-10
2
Medium Priority
?
211 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 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach 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 video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

809 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