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.

Previous Post

How to properly stop the Batch server and Accounting Tasks?

Next Post

Scheduled Downtime | 11 December 2021-12 December 2021

Related Post

HRMS Business HR ESS Payroll Knowledge base

Sage 300 People: How to set Web Self Service – Password Protected Payslip Print

Clock Image  13 Sep 2021 Read More
HRMS HR ESS Payroll Knowledge base Popular

Resolving the e@syFile Error; “e@syFile has detected that an encrypted database file for this company exists”

Clock Image  17 May 2022 Read More