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 cursors? : Sql server database administration

0 Answers  

How do you make a trace?

0 Answers  

How to create database with physical files specified in ms sql server?

0 Answers  

What are the types of constraints?

1 Answers  

How to copy the tables, schema and views from one sql server to another?

0 Answers  

How to list all schemas in a database?

0 Answers  

What are the system database in sql server 2008?

0 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

Define full outer join in sql server joins?

0 Answers  

how many triggers you can have on a table? : Sql server database administration

0 Answers  

How many cores do I need for sql server 2016?

0 Answers  

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories