what is difference between clustering and mirroring?

Answer Posted / sachin jain

1. Failover Cluster protects the instance, while DB
Mirroring protects one or more DBs.
2. failover clustering required dedicated H/W, while DB
Mirroring is not required dedicated h/w.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrive a single data from a database

794


What are the five steps of data modeling?

646


What are the key constraints in dbms?

701


What are indexes? Mention the differences between the clustered and non-clustered index?

686


Enlist some commands of ddl?

709


Define a relation schema and a relation.

730


How do you create a blank database?

663


Why do we use databases?

640


Explain the importance of partitioning.

708


Briefly describe an outer join.

696


How to unzip a file in ssis?

724


What is hashing in dbms?

721


What are the different stages in 'data warehousing'?

654


Can we linked SharePoint to a SQL databasebe?

777


What is an artificial (derived) primary key? When should it be used?

652