what is node in sql server?

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


Please Help Members By Posting Answers For Below Questions

Does full backup break log chain?

724


Describe in brief authentication modes in sql server.

720


What is raid and what are different types of raid levels?

771


What is difference between foreign key and unique key?

744


Can we install sql server 2016 on windows 7?

853






Can we store videos inside the sql server table?

703


What are the built in functions in sql server?

646


How can you stop stored procedures from recompiling?

632


What happens on checkpoint?

768


What is microsoft sql server?

687


What is SQL Azure Fabric?

106


Explain sql server service broker?

691


Tell me can we use custom code in ssrs?

742


Is it safe to delete log files?

667


Can group functions be mixed with non-group selection fields in ms sql server?

689