-
Go to Microsoft SQL Server Management Studio
-
Navigate to Object Explorer and select your server name
-
Expand the Database section and right click on the database, and select Tasks > Backup
-
On the back up window, Select General, and add these inputs in the Source section:
Backup Type
Full
Backup Component
Database
-
Add these inputs in the Destination section:
Backup To
Disk
Path
Path, filename of the backup
The default path and .bak file name are automatically populated.
-
Click OK.
-
This message is displayed after the backup process completes.
-
Click OK
Go to the default path as given in the first step and verify that you can view the backup. If you are unable to view it, repeat steps 2 to 6.