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 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)
LinkWithin
