Step 1: Open the sql server database, select the database to be backed up, and right-click the mouse to select Task->; Backup, as shown in the figure below:

Please click to enter a picture description.

Step 2: After entering the database backup interface, back up the complete database, and then see the default path of the backup database, as shown in the following figure:

Please click to enter a picture description.

Step 3: Click Add to modify the backup database path, as shown below:

Please click to enter a picture description.

Step 4 Select the default path for backing up the database here, and click OK to see that the database has been backed up successfully, as shown in the following figure:

Please click to enter a picture description.

In the fifth step, we can see that the database backup file is in the default path c: \ program files \ Microsoft SQL server \ MSSQL10 _ 50. MSSQL Server \ MSSQL \ backup \, as shown in the following figure:

Please click to enter a picture description.