Published on

How to backup a database with SQL Server Management Studio?

Authors

Logon to the SQL Server Management Studio.

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

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

Figure 2: Select backup
Figure 2: Select backup

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

Figure 3: Add Backup Destination
Figure 3: Add Backup Destination

Close the dialog and click "OK" to perform the backup.

Figure 4: Backup completed
Figure 4: Backup completed