Recovers data that is already consistent with the database and needs only to be made available. However, a piecemeal restore begins with a RESTORE DATABASE using the PARTIAL option and specifying one or more secondary filegroups to be restored. Restores the database in stages, beginning with the primary filegroup and one or more secondary filegroups. Page restore is available only under the full and bulk-logged recovery models. After a full file restore, a differential file backup can be restored. Note that under the simple recovery model, the file must belong to a read-only filegroup.
Restores a file or filegroup in a multi-filegroup database. Restores the entire database, beginning with a full database backup, which may be followed by restoring a differential database backup (and log backups).
SQL Server supports a variety of restore scenarios: In this tutorial, we will learn how to perform a database restore with options.
0 kommentar(er)
