Interview Questions
1. What is piecemeal Restore?
A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and
all read-write, secondary filegroups. Piecemeal restore process allows us to restore the primary filegroup first and the database
can be online and the remaining filegroups can be restored while the recovery the transactions are running on primary. Mostly
suitable for data warehousing databases.
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