Follow this procedure to backup your Microsoft SQL Server database.
Procedure
- Open SQL Server Management Studio.
- Open the Databases folder.
- Right-click your database.
- Select .
- Backup type should be Full.
- Enter a Name for the backup.
It is recommended that you use the format: yyyymmdd.projectname.bak to name the backup.
- Ensure that Backup set will expire: After 0 days
- In the Destination pane at the bottom of the window, click Add.
- Add a destination folder such as: yyyymmdd.projectname\SQLServer\Dump.
- Click Options in the left pane and verify that the information is accurate:
- Backup to the existing media set.
- Append to the existing backup set.
- Verify backup when finished.
- Click OK.
The backup of the database starts.