Restore Database

In this section, you will restore a database from a backup file into your SQL Server database.

Pre-requisite

  • MSSQL Server
  • SQL Server Management Studio (SSMS)
  • A database restore file stored in the default backup location. ( As explained in the download sample database section of the select page ).

Restore a database

  1. Open SQL Server Management Studio (SSMS), and connect to your database.

  2. In Object Explorer on the left, right-click Databases > Restore Database... to launch the Restore Database wizard.

    restore)

  3. Select General > Device.

  4. Select the 3 eclipses ... next to Device.

    select

  5. Locate the AdventureWorks2019.bak file from the default location, and click OK.

    backup created

  6. Select Add to add the Backup media file.

  7. Click OK to confirm your database backup selection and return to the main wizard.

    Complete

  8. Select OK to restore your database.

AdventureWorks2019 sample database is now available in the Object Explorer.

Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2024 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin