Weekly Review: Schedule Backups from Within Dynamics GP

Dynamics GP 9 and up allows you to schedule backups from within the application. You'll need to be logged in to GP as an administrator and you'll need to be on the server. Go to File-Backup. Enter the system password if you've set one. The backup window opens, pick Schedule.

1. Name the backup schedule
2. Pick the database to backup or backup the system databases
3. Enter the backup path (this must be a path on the local server)
4. Select the days to backup and the time. The time is entered is in a 24 hour format
5. Pick how often to delete old backups
6. Click Save. --SQL Agent MUST be running when you click save--

This process creates a job in the SQL agent with the information entered. You can modify the job through the GP interface or via SQL to set more advanced options (like notifications). No, I don't expect DBA's to be using this, they'll create their own SQL Jobs, but if you don't have a dedicated DBA, this is a good start. You'll still need to move the backups off the server for real protection but that's easier with today's portable hard drives. There's no excuse for not backing up your Dynamics GP installation now.

Originally Posted by Mark at 11/12/2009 09:00:00 AM