Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic presents examples of restore sequences for several restore scenarios. Where the sequences differ between the full and simple recovery models, examples of each are provided.
In This Section
- Example: Piecemeal Restore of Database (Simple Recovery Model)
- Example: Piecemeal Restore of Only Some Filegroups (Simple Recovery Model)
- Example: Online Restore of a Read-Only File (Simple Recovery Model)
- Example: Offline Restore of Primary and One Other Filegroup (Full Recovery Model)
- Example: Piecemeal Restore of Database (Full Recovery Model)
- Example: Piecemeal Restore of Only Some Filegroups (Full Recovery Model)
- Example: Online Restore of a Read/Write File (Full Recovery Model)
- Example: Online Restore of a Read-Only File (Full Recovery Model)
- Example: Offline Restore of Primary and One Other Filegroup (Full Recovery Model)
See Also
Concepts
Restore Restrictions Under the Simple Recovery Model
Overview of Restore and Recovery in SQL Server
Other Resources
Working with Restore Sequences for SQL Server Databases