Sage 300 People; how to take SQL database backup?
By A R | 23 Nov 2021 | knowledge base, sage 300 people, support,
Here is a step by step checklist to help you take the DB backup of your Sage 300 People installation. Please note, you will need access to SQL login credentials for this. Also, if this is your first time, keep our contact details handy, just in case.
Step 1: Open SQL Server Management Studio.
Step 2: Complete SQL Login credentials.
Step 3: Expand Databases and select the database that you want to backup.
Step 4: Right-click on the Database you wish to backup
Step 5: Select Tasks, make sure the backup type is set to full, set to disk and then Back Up
Step 6: Click Remove and then Add.
Step 7: Click the Browse button to select a required backup location and add a Backup name.
Step 8: Complete the backup by pressing the Ok button
If the backup is successful, you will see the notification.