How to backup a database with SQL Server Management Studio?

Logon to the SQL Server Management Studio.

Backup SQL Database 1
Figure 1: Logon to SQL Server Management Studio

Right click the database in question. Select “Tasks” and then “Back Up”.

Backup SQL Database 2
Figure 2: Select backup

Click on “Add” to add a destination folder and filename for the backup.

Backup SQL Database 3
Figure 3: Add Backup Destination

Close the dialog and click “OK” to perform the backup.

Backup SQL Database 4
Figure 4: Backup completed