answersLogoWhite

0

. 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

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is mirroring in sql server 2008?

Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine. Typically, these server instances reside on computers in different locations. Starting database mirroring on a database, initiates a relationship, known as a database mirroring session, between these server instancesDatabase mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as quickly as possible. Redoing is accomplished by sending a stream of active transaction log records to the mirror server, which applies log records to the mirror database, in sequence, as quickly as possible. Unlike replication, which works at the logical level, database mirroring works at the level of the physical log record. Beginning in SQL Server 2008, the principal server compresses the stream of transaction log records before sending it to the mirror server. This log compression occurs in all mirroring sessions


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What is the difference between database management and documents management systems?

differences between document management and database technology


What is the difference between a database management system and a database?

DBMS: Set of software applications combined w/ a database


What does it mean when the difference between mirroring and mimicking?

I love my cats, some are orange, some are grey, and some are black.


What is the Difference between manual database and electronic database?

A manual database is MANUAL and an electronic is electronic LOL! Simple :P


What iis difference between dbms and tfs?

database approach


Difference between flat file and database file?

DATABASE FILE - is one that is stored on a server and it is in the format that the database needs to read it. It is stored in the database catalog......


What is the difference between homogeneous database and heterogeneous database?

A Homogeneous database will have only one DBMS, while heterogeneous databases have multiple DBMS's


What is the difference between oracle and oracle erp?

Oracle is a database corporation that has many products such as Database, BI and ERP