What would you like to know more about?

Confirm Your Backup Destination

First, you need to confirm the backup destination for your SQL Maintenance Plan backup jobs. To find the backup location launch SQL Server Management Studio and log in to the SQL instance hosting your MinistryPlatform database. In the left-hand tree view expand Management > Maintenance Plans. You should see at least three plans.

  1. Right-click MinistryPlatform Full.
  2. Click Modify.
    This launches the Design view. Scheduling is in the top of the Design window, and Maintenance Plan Tasks are in the bottom.
  3. Right-click Backup Database (Full) task.
  4. Click Edit.
  5. Look for the Destination section of the job properties. For older versions the backup destination is on the first properties screen; in newer versions of SQL the backup Destination is on a separate tab. The backup path is under the section labeled Create a backup file for every database. Unless Create a sub-directory for each database is unchecked you will see a folder in the backup destination for each database that is being backed up.
  6. Make a note of the path.
  7. Click Cancel.
  8. Right-click Maintenance Cleanup Task.
  9. Click Modify.
  10. Look for the section labeled Delete files older than the following.
  11. Make a note of the maximum file age.

In most cases, the MinistryPlatform Full and MinistryPlatform Log plans have the same backup destination and retention settings, but you can repeat the above instructions for the MinistryPlatform Log job to verify it is using the same settings.