nerdexam

70-158 · Question #5

You administer a Forefront Identity Management (FIM) 2010 server in your company network. The server that runs the FIM Portal fails. You begin the restore process. However, you receive an error when…

The correct answer is D. Ensure that no stored procedure runs in FIM. To continue the restore process after encountering an error stopping the SQL Server Agent service for a failed FIM Portal, you must ensure that no active database processes, such as running stored procedures, are preventing the agent from shutting down.

Submitted by marco_it· Mar 4, 2026Install and upgrade FIM

Question

You administer a Forefront Identity Management (FIM) 2010 server in your company network. The server that runs the FIM Portal fails. You begin the restore process. However, you receive an error when you stop the SQL Server Agent service. You need to be able to continue the restore process. What should you do?

Options

  • ARun iisreset.exe.
  • BClose the FIM Portal.
  • CStop the FIM Synchronization service.
  • DEnsure that no stored procedure runs in FIM.

How the community answered

(38 responses)
  • A
    24% (9)
  • B
    5% (2)
  • C
    11% (4)
  • D
    61% (23)

Why each option

To continue the restore process after encountering an error stopping the SQL Server Agent service for a failed FIM Portal, you must ensure that no active database processes, such as running stored procedures, are preventing the agent from shutting down.

ARun iisreset.exe.

Running iisreset.exe restarts Internet Information Services (IIS), which hosts the FIM Portal, but it does not directly address an error preventing the SQL Server Agent service from stopping.

BClose the FIM Portal.

The FIM Portal server has already failed, so 'closing' the portal is either redundant or insufficient to resolve an issue with the SQL Server Agent service.

CStop the FIM Synchronization service.

Stopping the FIM Synchronization service would halt synchronization activities, but it might not directly resolve an issue preventing the SQL Server Agent service from stopping, especially if the problem lies with the agent's own jobs or other active database processes.

DEnsure that no stored procedure runs in FIM.Correct

The SQL Server Agent service manages scheduled jobs that often execute stored procedures within the FIM databases. If these procedures are actively running, holding locks, or have open transactions, they can prevent the SQL Server Agent service from stopping cleanly, which is a necessary step before performing a database restore.

Concept tested: SQL Server Agent service shutdown for database operations

Topics

#FIM Portal#Disaster Recovery#Database Restore#SQL Server Agent

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-158 Practice