What would you like to know more about?

Confirm Your Backup Destination

Confirm the backup destination for your SQL Maintenance Plans backup jobs.

  1. To find the backup location, launch the SQL Server Management Studio and log in to the SQL instance hosting your MinistryPlatform database.
  2. In the left-hand tree view, go to Management > Maintenance Plans. You should see at least three plans.
  3. Right-click MinistryPlatform Full.
  4. Click Modify.
    This launches the Design view. Scheduling is in the top of the Design window, and Maintenance Plan Tasks are in the bottom.
  5. Right-click Backup Database (Full) task.
  6. Click Edit.
  7. 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 not selected, you will see a folder in the backup destination for each database being backed up.
  8. Note the path, then click Cancel.
  9. Right-click Maintenance Cleanup Task.
  10. Click Modify.
  11. Look for the section labeled Delete files older than the following.
  12. Note 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 uses the same settings.