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

Backup and Restore F1 Help

This section contains the following F1 Help topics for the backup and restore dialog boxes in SQL Server Management Studio.

Back Up Database (General Page)

Back Up Database (Options Page)

Backup Device (General Page)

Backup Device (Media Contents Page)

Continue with Restore

Device Contents

Point in Time Restore

Restore Database (General Page)

Restore Database (Options Page)

Restore Files and Filegroups (General Page)

Restore Files and Filegroups (Options Page)

Restore Transaction Log (General Page)

Restore Transaction Log (Options Page)

Select Backup Destination

Select Backup Device

Select Files and Filegroups

Select Marked Transaction

Specify Backup

To Back Up a Database

  • How to: Back Up a Database (SQL Server Management Studio)

  • How to: Create a Differential Database Backup (SQL Server Management Studio)

  • How to: Back Up Files and Filegroups (SQL Server Management Studio)

  • How to: Back Up a Transaction Log (SQL Server Management Studio)

To Restore a Database Backup

  • How to: Restore a Database Backup (SQL Server Management Studio)

  • How to: Restore a Differential Database Backup (SQL Server Management Studio)

  • How to: Restore a Transaction Log Backup (SQL Server Management Studio)


Additional resources


  • Last updated on 2012-02-06

In this article

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