what is node in sql server?
- 2 Answers
- 24759 Views
- CarrizalSoft Technologies, Google, NIIT, Nittany, TATA, I also Faced
- E-Mail Answers
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 is the difference between local and global temporary tables?
Can we use where clause with group by?
Can you explain what is sql server english query?
Tell me when is the update_statistics command used?
What is 5nf in normalization form?
What is the maximum rows in sql server table?
What is in place upgrade in sql server?
What is sql server query analyzer?
How each E-R model constructs can be mapped to the relational model?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is sql profiler. What are the default templates with it? : sql server database administration
Do you know how to send email from database?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain system functions or built-in functions? What are different types of system functions?
What is postgresql server?
