Interested to Buy Any Domain ? << Click Here >> for more details...
what is node in sql server?
- 2 Answers
- 25538 Views
- CarrizalSoft Technologies, Google, NIIT, Nittany, TATA, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
How to delete existing triggers using "drop trigger"?
What is sql server profiler trace data file?
Which is faster statement or preparedstatement?
Difference between Logical Page and Physical Page in SSRS.
How to identify current user in ssrs report?
Differentiate between truncate vs delete in mssql?
How to use wildcard characters in like operations in ms sql server?
What is the language structure to add a record to a table?
What is the difference between substr and charindex in the sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is an entity-relationship diagram (erd)?
What is the recursive stored procedure in sql server?
What is the optimization being performed in oracle and SQL Server?
How can I know what locks are running on which resource?
