DB mirroring with SQL Server 2005: Standard vs. Enterprise
On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow automatic failover, Enterprise edition was [...]

Answer Question   |  March 31, 2010  10:21 PM
SQL Server, SQL Server 2005, SQL Server Database Mirroring

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring

Do all versions of Microsoft SQL Server 2005 support database mirroring?
Do all versions of Microsoft SQL Server 2005 support database mirroring?

Answer Question   |  April 8, 2009  5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring

Reporting and Mirrored SQL2005 DB
Can i access the sql2005 mirrored db via crystal reports for reporting

Answer Question   |  March 10, 2009  8:04 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring

SQL Server 2005 database mirroring over a VPN router
Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

Answer Question   |  February 27, 2009  3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers

SQL DB MIRRORING ACROSS VPN?
Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.

Answer Question   |  February 26, 2009  4:50 PM
SQL, SQL database replication, SQL Server Database Mirroring, VPN

Database Mirror connection string in sql 2008
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 [...]

Answer Question   |  February 13, 2009  7:30 PM
Database mirroring, SQL Server 2008, SQL Server Database Mirroring, SQL Server Mirroring