| | Back up a Sage 300 People database |
| 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 - Open SQL Server Management Studio
- Enter your SQL login credentials
- Contact the IT department for credentials if required
Select the database to back up - Expand Databases
- Select the database you want to back up
- The default Sage 300 People database name is People
Start the backup process - Right-click the selected database
- Select Tasks, then Back Up
- Confirm the following:
- Set the Backup type to Full
- Set Back up to Disk
Choose the backup location - Click Remove, then Add
- Click Browse to select the backup location
- Enter a backup name
Complete the backup - Click OK to start the backup
- A message will confirm if the backup was successful
- 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. |
|