I have a SQL Server 2008 Enterprice in a clustered environment and in active-active mode.
By active-active mode i mean that both instances are active and serving requests to their databases.
Instance 1 has databases Db_A and Db_B and instance 2 has databases Db_C and Db_D.
I would now like to create a new database called Db_E on each instance. They will have different content and structure, but will have the same name.
I tried it and it's possible but i'm not sure what will happen in the case of failover when i shut down Instance 1?
I guess it should be okay, but i'd like a confirmation.