SQL Mirror Database setup

Posted on 2012-09-13
Medium Priority
Last Modified: 2012-09-18
We have Desktop - Customer Management Application developed in .Net Framework running on multiple user computers. We use SQL 2008 Database for our .Net Application.

I am interested to mirror the SQL Database from Server 1 (Production Server) to Server 2.

1) SQL Backup scheduler is setup on Server1. How does this mirror feature works ? Whether Data on Server 1 will flow instantly to Server 2 ?? Does it depends on some kind of Trigger or Job Scheduler on Server 1 ??

2) Whether this will affect the SQL Backup Database Scheduler on Server 1?

3) Can we schedule the Backup activity on both Server 1 as well as Server 2?

4) What will happen if Server 1 or Server 2 fails like lost the network connection or something like that ?? How does Application will automatically switch from one server to another server ??

Can an expert clarify and help me to take a decision about setting up Mirror Database ??
Question by:chokka
  • 2
LVL 10

Accepted Solution

Ramesh Babu Vavilla earned 1500 total points
ID: 38395576
check my blog to setup mirroring

2) not it will not effect the backup job of the database

3)we can take Backup Jobs on the Server A, But not on the Server B,as the database on the Server B is in NO-Recovery mode

4)if the is a network Failure ,then Restart the MIrroring EndPoint

Author Comment

ID: 38395619

4) If there is a network failure or server down, then restart the mirror end point

Whether this will not do automatically ??

Author Closing Comment

ID: 38410930

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

850 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