Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

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.

In this article

Examples of Restore Sequences for Several Restore Scenarios

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 (Full Recovery Model)

  • Example: Piecemeal Restore of Database (Simple Recovery Model)

  • Example: Piecemeal Restore of Only Some Filegroups (Full Recovery Model)

  • Example: Piecemeal Restore of Only Some Filegroups (Simple 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: Online Restore of a Read-Only File (Simple Recovery Model)

  • Example: Offline Restore of Primary and One Other Filegroup (Full Recovery Model)

See Also

Concepts

Restore Restrictions Under the Simple Recovery Model

Restore and Recovery Overview (SQL Server)

Other Resources

Working with Restore Sequences for SQL Server Databases


Additional resources


  • Last updated on 2010-10-01

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026