FIM Service Backup and Restore

Applies To: Forefront Identity Manager 2010

The FIM Service exposes a Web service interface to manipulate enterprise resources. These resources are stored in one database. Backing up this database is sufficient to preserve customer data, such as users and groups and portal configuration. This section describes the items that you should back up for the FIM Service. It also contains a procedure for restoring the FIM Service.

Backing up the FIM Service

To ensure that you can preserve and restore your FIM Service, you must back up the following items:

  1. SQL Server database

    1. By default this database is called FIMService.

    2. You do not have to stop the FIM Service when you create this backup.

    3. If you added configuration data that was not included in the Setup process, you can also back up those items.

    4. The FIM Service database is deployed in full recovery model by default. Using the full recovery model makes it possible to back up the log to provide incremental recovery points. See Backup Under the Full Recovery Model ( for more information.


      The Full Text Index is used in the FIMService for object queries. In order to back up the Full Text indexes, the database recovery model must be set to Full, otherwise the Full Text indexes must be repopulated after the restore of the database.

  2. The .NET Application Configuration File, which is located at %programfiles%\Forefront Identity Manager\2010\Service\Microsoft.ResourceManagement.Service.exe.config.

  3. The following registry keys under the path HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FIMService:

    • DatabaseServer

    • DatabaseName

    • CertificateThumbpoint

    • DefaultKeySize

    • DefaultTokenLifetimeInMinutes

    • ServiceAccountSid

    • PollExchangeEnabled

  4. SQL Server Agent Jobs:

    • FIM_DeleteExpiredSystemObjectsJob

    • FIM_MaintainGroupsjob

    • FIM_MaintainSetsJob

    • FIM_TemporalEventsJob

    To back up a SQL Server Agent job

    1. Start SQL Server Management Studio.

    2. Expand the SQL Server Agent folder, and then expand the list of Jobs.

    3. Right-click the job you want to create a backup script for, and then select Script Job as.

    4. Click CREATE To or DROP To, then click New Query Editor Window, File, or Clipboard to select a destination for the script. Typically, the destination is a file with a .sql extension.

    5. Repeat this procedure from Step 3 for each job you want to script.


You can restore most configuration files and registry key settings by running Setup again. The SQL Server Agent Jobs will be re-created when you install the FIM Service.

Restoring the FIM Service

Use the following procedure to restore the FIM Service.

Restore the FIM Service

  1. Install the FIM Service on a computer in the same Active Directory domain as the FIM Service was previously installed. When installing the FIM Service to a new database the SQL Server Agent Jobs are automatically restored.

  2. Ensure that the FIM Service and SQL Server Agent are not running. If it is not possible to stop the SQL Server Agent, ensure that the FIM stored procedures are not running and disabled. Use the appropriate method for restoring the database, depending on your backup type and the data that you want to recover. See Restore and Recovery Overview (SQL Server) ( for more information.

  3. Restore the SQL Server database. It may be necessary to close open connections on the SQL Server database. For more information, see sp_who (Transact-SQL) (

  4. Restore the .NET Application Configuration file.


    1. If you are restoring the file on a different computer from the one that hosted the FIM service previously, replace the computer name in this configuration file with the new computer name.

    2. If you are restoring the file in a test environment, ensure that the Exchange server address is for a nonproduction computer.

  5. Restore the registry key values.

  6. Restore the SQL Server Agent jobs.

    To restore a SQL Server Agent job

    1. Start SQL Server Management Studio.

    2. Click File, click Open, then click File.

    3. Right-click the job you want to create a backup script for, and then select Script Job as.

    4. Locate and open the file containing the scripted job.

    5. Run the script to create the job.

  7. Start the FIM Service and SQL Server Agent.

See Also


FIM 2010 Backup and Restore Guide
Recommended FIM Backup Schedule
FIM Portal Backup and Restore
FIM Synchronization Service Backup and Restore
Testing FIM Backups
Case Study: How Microsoft Deploys Disaster Recovery for FIM 2010