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:
Add these inputs in the Destination section:
Path, filename of the backup
The default path and .bak file name are automatically populated.
This message is displayed after the backup process completes.
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.