Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

Explain mixed authentication mode of sql server?

0 Answers  

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

what is diffrent between store procedure and trigger

2 Answers  

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

could u plz explain about joins and views?

2 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

What is the maximum size of a row in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories