Back to lesson
1. How do you backup a database with SSMS?
Right click your database in the object explorer and select "Tasks" and then "Backup".
Just copy the database file in Windows explorer.
Right click your database in the object explorer and select "Backup".
2. What type of file extension should you save your backup as?
3. How do you restore a database?
Right click the Databases folder in object explorer, and select "Restore Database".
Use the Import Now Feature.
Drag and drop your backup file into the object explorer.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement