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
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?
Answer Question | April 8, 2009 5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
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
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
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
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