What is database mirroring?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is database mirroring?
Rating:
Database mirroring is a new feature in SQL Server 2005 that allows a user to maintain an exact copy of a database on a different server. It is used to increase database availability. It is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. In database mirroring, a SQL Server 2005 computer acts as a principal server, mirror server, or witness server. The system databases such as the master, msdb, temp, and model databases cannot be mirrored.
Rating:
Was this information helpful?
Other articles
- What are collation settings?
- What is SQL Server Configuration Manager?
- What is an HTTP endpoint?
- What is the table datatype?
- What is database snapshot?