Interview Questions
1. What are Partial Backups in SQL Server?
Partial backups are useful whenever you want to exclude read-only filegroups. A partial backup resembles a full database
backup, but a partial backup does not contain all the filegroups. Instead, for a read-write database, a partial backup contains
the data in the primary filegroup, every read-write filegroup, and, optionally, one or more read-only files. A partial backup of a
read-only database contains only the primary filegroup.
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