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.

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

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

Explain partitioned view?

0 Answers  

---

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

---

What languages bi uses to achieve the goal?

0 Answers  

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

What is the distinction amongst delete and truncate?

0 Answers  

---

Explain unique key in sql server?

0 Answers  

---

What do you mean by recursive stored procedure?

0 Answers  

---

Why would you call update statistics?

0 Answers  

---