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 is data mart? : sql server analysis services, ssas

0 Answers  

What are the advantages dts has over bcp?

0 Answers  

Can we insert data into a view?

0 Answers  

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

How do you clear a log file?

0 Answers  

Explain about protocol layer present in SQL server?

0 Answers  

Explain the concepts and capabilities of sql server?

0 Answers  

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

7 Answers  

Which joins are sql server default?

0 Answers  

Where views are stored in sql server?

0 Answers  

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories