We are implementing database mirroring for high availability. I have few questions.
1) The documentation says that only 10 databases are supported in an instance on a 32bit system. Are they referring to 32 bit windows system or 32 bit SQL server?
2)What's the best way to maintain the master and msdb consistency between the principle and mirror servers as these system databases aren't replicated (or mirrored)?
3)Is there anything similar to heartbeat in database mirroring? If so, can I force both principle and mirror to exchange their heartbeats on a private LAN? We will have two SQL servers in mirror with two NICs on each server. I would like to force the heartbeats on NIC1 and client traffic on NIC2. The NIC1 in both servers will be patched by a crossover cable.
4)For the classic ASP page, ASP.NET page, .NET apps, how the connection string should look like for the failover scenerio? I realize I need to include the Database=primary;partner = mirrorsql;... for ASP pages.
Last but not the least, can someone explain Microsoft's logic behind not mirroring or replicating the system databases? I am guessing some limitations are delibrately left unaddressed so that companies will buy the more expensive SQL cluster systems.
Thanks
1) The documentation says that only 10 databases are supported in an instance on a 32bit system. Are they referring to 32 bit windows system or 32 bit SQL server?
2)What's the best way to maintain the master and msdb consistency between the principle and mirror servers as these system databases aren't replicated (or mirrored)?
3)Is there anything similar to heartbeat in database mirroring? If so, can I force both principle and mirror to exchange their heartbeats on a private LAN? We will have two SQL servers in mirror with two NICs on each server. I would like to force the heartbeats on NIC1 and client traffic on NIC2. The NIC1 in both servers will be patched by a crossover cable.
4)For the classic ASP page, ASP.NET page, .NET apps, how the connection string should look like for the failover scenerio? I realize I need to include the Database=primary;partner = mirrorsql;... for ASP pages.
Last but not the least, can someone explain Microsoft's logic behind not mirroring or replicating the system databases? I am guessing some limitations are delibrately left unaddressed so that companies will buy the more expensive SQL cluster systems.
Thanks