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

what are batch in sql server?

2 Answers   Satyam,

Explain ranking functions?

0 Answers  

What is a with(nolock)?

0 Answers  

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

What is difference between count (*) and count column?

0 Answers  

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

What is data compression?

0 Answers  

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

What is difference between drop truncate and delete?

0 Answers  

what is memory-optimized nonclustered indexes

0 Answers  

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

How to convert numeric expression data types using the cast() function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories