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