In this tutorial I will teach you how to Backup SQL Database in your SQL Server Management Studio (SSMS). This will save you from losing your data in case of any SQL Server problem.
The following steps explain how to do Full Backup of your database using SSMS.
Click the plus sign in-front of the Databases node. This will show all the databases.
Right click on the database you want to backup then select “Tasks > Back Up”. This will open the Back Up Database window.
In the Back Up Database window there are 3 options for the Backup type – “Full”, “Differential” & “Transaction Log”.
Select the Full one.
On the Destination area you will see the Backup destination is already provided by the SQL Server. This location is:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup.
Finally click the OK button to Backup your database.