Backup a database using SQL Server Management Studio

Thursday 12 June 2014, by Younus Kazi

How to create a full database backup using SQL Server Management Studio?

In Object Explorer, click the server name to expand the server tree.
Expand Databases, Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
In the Database list box, verify the database name. You can optionally select a different database from the list.
In the Backup type list box, select Full. After creating a full database backup, you can create a differential database backup.
Either accept the default backup set name suggested in the Name text box, or enter a different name for the backup set.
Choose the type of backup destination by clicking Disk.
To select the paths click Add. The selected paths are displayed in the Backup to list box. To remove a backup destination, select it and click Remove.
To view or select the advanced options, click Options in the Select a page pane.
Accept default settings and click OK to complete the backup.