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 ??
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