The SERVERS sidebar allows you to access the TutorialDB database dashboard. Then press Ctrl+G to expand Databases, right-click TutorialDB, and choose Manage from the menu.
- Select Backup from the Tasks widget to open the Database Backup dialogue box.
- The Tasks widget as seen in a screenshot.
- The default backup options are used in this tutorial, so choose Backup.
- The Task History window is shown in this screenshot.
- Right-click Backup Database Succeeded and select Script to see the backup script in the editor.
- This is a screenshot of the backup script.
- Ctrl+G will bring up the SERVERS sidebar. Then pick Manage from the context menu when you right-click your server.
- Select Restore from the Tasks widget to open the Restore database dialogue box.
- A screenshot of the Task Restore feature.
- In the Restore from box, choose Backup file.
- In the Backup file path box, click the ellipses (...) and choose the most recent backup file for TutorialDB.
- To restore the backup file to a new database, type TutorialDB Restored in the Target database box in the Destination section. Then choose Restore from the drop-down menu.
- Restore backup is seen in this screenshot.
- Select Ctrl+T to open the Task History and check the status of the restore procedure.