How to backup:
Go to Start -> SQL Server Management Studio
Enter Login information. The default username is “sa” and password is “Prima123Vera”
Select the database, right-click, go to Task -> Back Up
Click on “Add” button
Select the backup file destination
Enter backup file name
Click OK to start the backup
Then we’ve got the backup file in our hard-drive
How to restore database:
Right click on Database and select Restore database
Select database to overwrite or enter a new name to create a new database from the backup file.
Select “From device” and choose backup file
Change Files of type to “All files” then you can see your backup file. Select the backup file
Check on “Restore”
Go to “Option”. Check on “Overwrite the existing database”
Click OK. And database will be restored.
