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...


what is node in sql server?

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

Define views.

0 Answers  


How do you identify a foreign key?

0 Answers  


How to create a local temporary stored procedure?

0 Answers  


What is the difference between insensitive and scroll cursor?

0 Answers  


how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,


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

5 Answers   Wipro,


What are clustered and non-clustered index?

0 Answers  


What is the purpose of grouping data in a report?

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


Anyone please explain me the concept of Serialization?

3 Answers  


What is the difference between left and right outer join?

0 Answers  


Does union all remove duplicates?

0 Answers  


Categories