What is Check pointing in SQL Server ?

If you are adding new data to a database, the new data is first written to a memory buffer, then written to the transaction log, and finally persisted to a data file via a background process called check pointing.

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

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