SQL Mirror Database setup

Posted on 2012-09-13
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
    LVL 10

    Accepted Solution

    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


    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


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how the fundamental information of how to create a table.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now