Interested to Buy Any Domain ? << Click Here >> for more details...
what is node in sql server?
- 2 Answers
- 25428 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 are the tools available in market as an alternative to sql server reporting services?
How do I connect to sql server database?
What are Row versions of DataRow?
Differentiate between ms sql server reporting services vs crystal reports?
What are the steps to process a single select statement?
what method you can use to reduce the overhead of Reporting Services data sources?
What are the different types of triggers in SQL SERVER?
define and explain the differences between clustered and non-clustered indexes.
What is buffer cash and log cache in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How can you start sql server in different modes?
What happens when transaction log is full?
Tell me about builtinadministrator?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What do you mean by data manipulation language?
