Hi,

In a little over 3 months our FIM Sync database has grown to over 30GB.

At the SQL database level, there do not appear to be any default jobs to archive/purge data. Is there anything in FIM Sync itself - other than clearing the Run Profile history?

Do FIM SQL backups do anything?

I assume the FIM Sync database is just expected to grow over time?

Thanks,

SK

Unfortunately there is a piece of information missing.
What was the size 3 months ago, so to see if the growth is abnormal.  And what is the population of objects being managed; users and groups.

One thing to do is to purge Transaction_log table

Sure, we started off with about 2GB.

MV has 100 users, 25 Groups, 1-5 delta transactions per day.

this is not right. The next thing to check is what table is growing. I really think is transaction logs. Thete is not mich you can do on FIM side - to answer your original question.

thank you, you mention purging the Transaction_log table...not being a SQL person, is this something easily done via a script? stored procedure? is there anything in the out of the box FIM Sync database stored procedures section?

where can I read up more about it and learn? thank you

Hello Shim.

The first question is: how are you backing up your environment?

Transaction log can be easily cleaned if you have full backups made straight from SQL (for example by job or manually with Management Studio). If you are backing up using other tool or by creating a snapshot of SQL VM, the best option would be to change Recovery Model option of FIMSyncService to Basic instead of Full.

Then you can shrink log file. For example using the following: Shrink a File