what is node in sql server?
Answers were Sorted based on User's Feedback
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 |
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 |
What does <> symbol mean?
What are different types of replication in sql server?
how to get the salary in descending order with out using the keyword desc in sql
select top 5 * from emp order by newid() my question is , how this query get executed?
Which is best Subquery (or) joins in sql server? explain why
How to join two tables in a single query in ms sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is table-valued sub query?
What is the command dbcc checkdb used for?
Explain few examples of stored procedure over triggers?
How to convert numeric expression data types by assignment operations?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)