What is a failover cluster?
Sunday, May 6, 2012
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 EarningWhat 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 EarningWhat 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 EarningWhat is the expansion of RMO ?
Replication Management Objects.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat 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 Earningwhat 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 EarningWhat are the 3 types of Server instances in SQL Server Mirroring ?
Saturday, May 5, 2012
1.Principal Server 2. Mirror Server 3. Witness Server
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and EarningWhat are the 3 recovery models in SQL Server?
Friday, May 4, 2012
1. Simple 2. Bulk-logged 3. Full
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Subscribe to:
Posts (Atom)
