The following data stores should be included in any backup and recovery plan for the solution platform.

Table: Data Stores and Backup Intervals

Data store Backup interval Recovery source Tools required Dependencies

Active Directory (Active Directory store)

24 hours

Backup domain controllers

Active Directory tools

RMDB, PlansDB, Microsoft Exchange Server 2007 mail stores

Exchange mail stores

24 hours

  • Disk backup
  • Transaction logs
  • Tape backup

Exchange tools

RMDB, PlansDB, Active Directory

Exchange public stores

24 hours

  • Disk backup
  • Transaction logs
  • Tape backup

Exchange tools

RMDB, PlansDB, Active Directory

Resource Manager database (ResourceManager)

24 hours

  • Disk backup
  • Transaction logs
  • Tape backup

Microsoft SQL Server 2005 (contact Microsoft support if no backup)

PlansDB, Active Directory, Exchange stores, SharePoint Services

Customer Plans database (PlanManager)

24 hours

  • Disk backup
  • Transaction logs
  • Tape backup

SQL Server (contact Microsoft support if no backup)

PlansDB, Active Directory, Exchange stores

Microsoft Provisioning System (MPS) transaction logs (PlanManager, ResourceManager)

Every 10 minutes to every hour, depending on volume

  • Disk backup
  • Tape backup

SQL Server

None

MPS audit logs (MPFAudit)

24 hours

  • Disk backup
  • Tape backup

SQL Server

None

MPF Configuration Database (MPFConfig)

24 hours

  • Disk backup
  • Tape backup

SQL Server

None

PWDB40

24 hours (change to simple recovery model or do transaction log backups as well)

Microsoft System Center Operations Manager 2007 OnePoint database

SQL Server

Operations Manager OnePoint

SharePoint Services (WSS_Content, SharePoint_Config, SharePoint_AdminContent_xxx, WSS_Search_xxx)

24 hours

  • Disk backup
  • Transaction logs
  • Tape backup

SQL Server

RMDB, PlansDB, Active Directory

SharePoint Transaction Logs (WSS_Content, SharePoint_Config, SharePoint_AdminContent_xxx)

As dictated by voume of changes

  • Disk backup
  • Tape backup

SQL Server

None