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

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
Who is Participating?
ivanovnConnect With a Mentor Commented:
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:
rdbconceptsAuthor Commented:
Thats great - thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.