Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlmyworld
Starting Member
38 Posts |
 Posted - 2012-08-14 : 01:14:23
|
| This is first time I am installing Active/Active 2008 R2 cluster on Windows 2008 R2 server. I am installing SQL system databases on specific dedicated drive D (means not default C: Drive) and it is local drive to server on both nodes. Now Let say node 1 has db1, db11, db111 and node2 has db2, db22 and db222. when one node failed over to another (for example node 1 failed) how db1, db11 and db111 are available as the drive D (of node 1) is not failed over which contains system db (master, msdb etc)? Also we have separate drives (SAN) for Data, log, backup and tempdb for both nodes.Thanks in Adv. |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-14 : 05:35:32
|
| While you are installing, choose shared drive(SAN) for all databases path including system database(master, msdb, tempdb etc), otherwise you can not failover to another node.- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulCurrently be a DBA in worldwide hotel reservation. Experienced in top leading banking environment. |
 |
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2012-08-14 : 21:22:53
|
| Thanks Komkrit. I successfully installed failed over cluster with SQL default instance. |
|
|
|
|
|
|
Active Active 2008 R2 Cluster