1. Open SQL Server Management Studio and connect to the SQL server.You can connect to SQL server using Windows Authentication or SQL Authentication
2. Expand Databases in left side panel.
3. Right-click on the database you want to back up, then select Tasks > Back up.
4. On the Back Up Database dialog box, make sure the Database field contains the name of the database you want to back up.
5. In the Backup type drop-down list, select the desired backup type - the default is Full.
6. Under Backup component, select Database.
7. In the Destination section, review the default location for the backup file. Click Remove to remove the default backup file name.
8. Click Add to open the Select Backup Destination window.
9. Click ... next to the File Name field.
10. On the Locate Database Files window, select the folder where you want to save the database backup file.
11. In the File Name field, type the name for this backup, with a .bak extension. For example, 1example_2020_04_02.bak for a backup of the 1example database created on 02 April 2020.
12. Click OK to close the Locate Database Files window.
13. Click OK to close the Select Backup Destination window.
14. Click OK to start the backup. You can see the backup progress icon displayed in the lower-left corner, and a ‘completed successfully’ message once the backup complete.
