- Published on
How to backup a database with SQL Server Management Studio?
- Authors
- Name
- Michael Groncki
- @dergroncki
Logon to the 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
Click on "Add" to add a destination folder and filename for the backup.
Figure 3: Add Backup Destination
Close the dialog and click "OK" to perform the backup.
Figure 4: Backup completed