What is a failover cluster?

A group of servers that are in one location and that are networked together for the purpose of providing live backup in case one of the servers fails.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Failover ?

To switch processing from a failed component to its backup component.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Mirroring in SQL Server 2005 ?

Database mirroring is a primarily software solution for increasing the probability that a database is available. Mirroring is implemented on a per database basis and works only with databases that use the full recovery model.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of RMO ?

Replication Management Objects.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Replication ?

It is copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

what are the Database files in sql server ?

1. Primary data files (.mdf) 2. Secondary data files (.ndf) 3. Log files (.ldf)

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning