what is node in sql server?
Answer Posted / mamatha
A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime.
Is This Answer Correct ? | 37 Yes | 6 No |
Post New Answer View All Answers
What are the dis_advantages of stored procedures, triggers, indexes?
What are 3 ways to get a count of the number of records in a table?
What are different types of subquery?
If the job running very slow what is the action you do
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the sql case statement used for?
What is 'Join' and explain its various types.
What is update_statistics command?
How to download and install microsoft .net framework version 2.0?
what is dbcc? : Sql server database administration
What is openrowset sql server?
What functions can a view be used to performed?
Explain error and transaction handling in sql server?
What is the current limitation of the size of SQL Azure DB?
What is the latest version of microsoft sql server?