The following table introduces the possible restore scenarios that are supported for different recovery models.
The supported restore scenarios depend on the recovery model of the database and the edition of SQL Server. Overview of Restore ScenariosĪ restore scenario in SQL Server is the process of restoring data from one or more backups and then recovering the database. For information about support for backups from earlier versions of SQL Server, see the "Compatibility Support" section of RESTORE (Transact-SQL). For information about the supported operating systems, see Hardware and Software Requirements for Installing SQL Server 2016. SQL Server backup and restore work across all supported operating systems. Page restores can be performed on any database, regardless of the number of filegroups. Under the full recovery model or bulk-logged recovery model, you can restore individual pages. Any attempt to access an offline filegroup causes an error.
During a file restore, the filegroups that contain the files are automatically offline for the duration of the restore. The whole database is restored and recovered, and the database is offline for the duration of the restore and recovery operations.Ī data file or a set of files is restored and recovered. The database (a complete database restore) SQL Server restore and recovery supports restoring data from backups of a whole database, a data file, or a data page, as follows: To recover a SQL Server database from a failure, a database administrator has to restore a set of SQL Server backups in a logically correct and meaningful restore sequence. Applies to: SQL Server (all supported versions)
0 kommentar(er)
