The backup of your SQL database using SQL Server Management Studio is usually done by IT or an experienced system administrator. Consult them first to proceed with the below.
Follow the below steps:
Open SQL Management Studio.
Enter your server name.
Login using Windows or SQL authentication.
Expand on the Databases folder .
Right click the aps_dsql database.
Select Tasks, Back Up...
Ensure that the Source Database is aps_dsql (your APS database).
Ensure the Back up to reads Disk.
Click Add.
File Name: click the ellipsis to select a backup location.
Select the Location you wish to save the backup file.
Ensure the file extension is .BAK in the file name. For example: aps_dsql_ddmmyear.bak
Click OK. You will see the backup in progress in the bottom left corner.
Click OK to the pop up The backup of database 'aps_dsql' completed successfully.
The backup has completed successfully. Upload the backup to the file share location provided by your support analyst.
