what is node in sql server?
Answer Posted / sumit
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 ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is DCL?
Which sql server table is used to hold the stored procedure script?
What are some examples of schemas?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the recovery model? List the types of recovery model available in sql server?
What is normalization of database? What are its benefits?
What are the triggers in sql?
Which is the latest version of sql server and when it is released?
How to create “dependant” parameter “make, model, year”
Explain throw statement in sql server 2008?
Show Practically Sql Server Views are updatable?
What are the new features in sql server 2016?
What are the tables in sql?
What is a trigger and types of a trigger?
Explain having clause?