Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is node in sql server?

Question Posted / manojpatil27@gmail.com

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 can do you the system monitoring?

1 Answers  

How to use subqueries in the from clause in ms sql server?

0 Answers  

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

what is database replicaion? : Sql server database administration

0 Answers  

what is the difference between group and having give an example with query and sample output

7 Answers  

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

How to get the definition of a user defined function back?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories