SQL Database backup
Open SQL Server Management Studio
Complete SQL Login credentials
The login credentials for SQL can be obtained from the IT department.
Expand Databases and select the Database that needs to be backup
Sage 300 People default SQL database name might be different
Right-click on the Database you want to backup
Select Tasks and then Back Up..
Make sure of the following, the Backup type is set to Full and the Back up to is set on Disk.
Click Remove and then Add.
Click the Browse button to select a required back up location and add Backup name
Complete the backup by pressing the Ok button
A Message will indicate if the backup was successful. Once successful click OK and then close SQL Management Studio.