what is node in sql server?

Answers were Sorted based on User's Feedback



what is node in sql server?..

Answer / 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

what is node in sql server?..

Answer / 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

More SQL Server Interview Questions

How to list all stored procedures in the current database using ms sql server?

0 Answers  


How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  


What do you mean by acid?

0 Answers  


What are page splits? : SQL Server Architecture

0 Answers  


what is meant by deafult in sql server?

2 Answers  


what's sql server? : Sql server database administration

0 Answers  


How to override dml statements with triggers?

0 Answers  


What is the difference between TRUNCATE and DROP?

0 Answers  


What new changes are being made in SQL Server?

0 Answers   Blue Star,


How to insert data into an existing table?

0 Answers  


How many types of functions are there in sql server?

0 Answers  


OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  


Categories