Explain Active/Active and Active/Passive cluster
configurations?
Answer / suman j
Here first node will be default and second node will be
named instance. Both node will be active.
Move group from cluster administration is possible for both
side.
System performance will go down, if both resources are in
one node.
Active/Passive
Only one Active node with default instance.
No system performance degradation will be there for this
case even if we switchover to the other node. Both have
same configuration.
| Is This Answer Correct ? | 1 Yes | 0 No |
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What do you mean by COLLATION?
How do we know if any query is retrieving a large amount of data or very little data?
What is rank function?
Do comments need to go in a special place in sql server 2005?
Can you give an example of Stored Procedure?
What is a ddl statement?
wat is mean by normalization?......programing defination i need...(i know basic defination)
how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.
How do you clear a log file?
What is a non clustered primary key?
Why do we use non clustered index?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)