For more information, see Restore Pages - SQL Server. Page restore is available only under the full and bulk-logged recovery models. For more information, see File Restores - Full Recovery Model and File Restores - Simple Recovery Model. After a full file restore, a differential file backup can be restored. Under the simple recovery model, the file must belong to a read-only filegroup. Restores a file or filegroup in a multi-filegroup database. For more information, see Complete Database Restores - Simple Recovery Mode or Complete Database Restores - Full Recovery Model. 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: To Revert a Database to a Database Snapshot:įROM DATABASE_SNAPSHOT = database_snapshot_nameįILE = įor descriptions of the arguments, see RESTORE Arguments. To Restore Specific Files or Filegroups:

To perform the first step of the initial restore sequence of a piecemeal restore: To Restore an Entire Database from a Full database backup (a Complete Restore): For more information about descriptions of the arguments, see RESTORE Arguments.Backup and restore to S3-compatible object storage was introduced in SQL Server 2022 (16.x). For more information, see SQL Server backup to URL for S3-compatible object storage. For more information about restoring from S3-compatible object storage, see SQL Server backup and restore with S3-compatible object storage preview.For more information about restoring from the Microsoft Azure Blob Storage, see SQL Server Backup and Restore with Microsoft Azure Blob Storage.When restoring a database from another instance, consider the information from Manage Metadata When Making a Database Available on Another Server Instance (SQL Server).For more information about SQL Server restore scenarios, see Restore and Recovery Overview.Revert a database to the point in time captured by a database snapshot.Restore a transaction log onto a database (a transaction log restore).

Restore specific pages to a database (a page restore).

Restore specific files or filegroups to a database (a file restore).

Restore part of a database (a partial restore).Restore an entire database from a full database backup (a complete restore).This command enables you to perform the following restore scenarios:

Sql server restore master