What are the various types of backups in sql server ?

1•Full backups 2•Differential backups 3•File backups 4•Filegroup backups 5.Partial backups 6•Copy-Only backups 7•Mirror backups 8•Transaction log backups

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

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

What are the 3 types of Server instances in SQL Server Mirroring ?

1.Principal Server 2. Mirror Server 3. Witness Server

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

What are the 3 recovery models in SQL Server?

1. Simple 2. Bulk-logged 3. Full

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