Interview Questions
1. What are Mirrored Backup Media Sets?
Mirrored backup media sets are supported only in the Enterprise edition of SQL Server.
Mirroring a media set increases backup reliability by reducing the impact of backup-device malfunctions. These malfunctions
are very serious because backups are the last line of defense against data loss. As database grows, the probability increases
that a failure of a backup device or media will make a backup non restorable. Mirroring backup media increases the reliability
of backups by providing redundancy.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment