Skip to content
logo Knowledgebase

Back up a Sage 300 People database

Created on  | Last modified on 

Summary

How to back up a Sage 300 People database using SQL Server Management Studio. It applies to all Sage 300 People installations.

Description

Ensure you have the correct SQL login credentials before starting. Contact your IT department for assistance if needed.

Resolution

 

Open SQL Server Management Studio

  1. Open SQL Server Management Studio
  2. Enter your SQL login credentials
    • Contact the IT department for credentials if required

Select the database to back up

  1. Expand Databases
  2. Select the database you want to back up
    • The default Sage 300 People database name is People

Start the backup process

  1. Right-click the selected database
  2. Select Tasks, then Back Up
  3. Confirm the following:
    • Set the Backup type to Full
    • Set Back up to Disk

Choose the backup location

  1. Click Remove, then Add
  2. Click Browse to select the backup location
  3. Enter a backup name

Complete the backup

  1. Click OK to start the backup
  2. A message will confirm if the backup was successful
  3. Click OK, then close SQL Server Management Studio

 

A Message will indicate if the backup was successful. When successful, click OK, and then close SQL Management Studio.