Moving the FIM 2010 R2 SQL database (or renaming the database)

Shutdown any jobs on FIM. Shut down the FIM Service in services.cpl.

 

Backup the DB from the SQL Manager

Move it, rename it, restore it.

On the new DB server, set the FIM service account you are using as DB_Owner

 

On the FIM server

Open RegEdit
    Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\FIMSynchronizationService\Parameters

        Server is the name of the new SQL Server (it would have been blank if the local server was the SQL server)

        DBName is the file name in the remote SQL Server

        SQLInstance Property should equal the name of the instance (default instance, then it should be blank)

Start the FIM Services

 

Hat-tip: http://social.technet.microsoft.com/wiki/contents/articles/5465.fimilm-how-to-move-the-backend-sql-server-synchronization-service-database.aspx  (note this says Server Property inferring the key is called “Server Property“ it is just “Server”