what is node in sql server?
Answer Posted / 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 View All Answers
What are advantages of ssrs or why we should use ssrs?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to create a ddl trigger using "create trigger" statements?
List types of tables in SQL Azure?
what does the automatic recovery do? : Sql server administration
Explain about SQL server 2005?
What is history table in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is the bookmark lookup and rid lookup?
What are Row versions of DataRow?
Explain sql server service broker?
What is wide table?
When you should use a low fill factor?
What are points to remember while using the fillfactor argument?
How to select some specific rows from a table in ms sql server?