Hello! We have 2 Oracle MA, FIM MA and AD MA. The data flow is Oracle MA's -> FIM MA -> ADMA. While we are performing Export operations on FIM MA, the SQL TEMP database log file grows up (approximally 1000 records = 1.1GB). I see in this thread http://social.technet.microsoft.com/Forums/sa/ilm2/thread/67e2b6f8-3d18-4904-8858-0ba921df3169 that we can do the regular "dbcc ShrinkFile('tempdblog.ldf')" operations. But the article says that: "IMPORTANT: You must run DBCC SHRINKFILE command while no other activity occurs in the tempdb database. To make sure that other processes cannot use tempdb while DBCC SHRINKFILE executes, you must restart SQL Server in the single user mode. For more information about DBCC SHRINKFILE, see theEffects of Execution of DBCC SHRINKDATABASE or DBCCSHRINKFILE While Tempdb Is In Usesection of this article." I assume that the tmp db is active while the FIM MA Export is in progress. Questions: 1. What is the best recomended way to resize smaller Temp DB during the FIM MA Export operation is in the progress? Can I run "dbcc ShrinkFile('tempdblog.ldf')" ? 2. I have the following plan. Is it correct (Can I export the data in to multiple iterations and then run Delta import or I need to run Delta import after each export operation?)? On FIM MA Export Profile configure maximum amount of records to be exported. When export stops, restart SQL service (to resize Temp DB to its original size). Then adjust FIM MA Export Profile configure maximum amount of records to be exported for the twice. Run export again. When Export Finished run Delta import (or Full import?), then Full SYNC. Now I run the export with exported item limit. Now we need to understand- if the plan above is correct. Please correct me If I need to do things in other sequence. Thanks!

I'm unclear as to why you want to do this in the first place?My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

I'm unclear as to why you want to do this in the first place?My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

I'm trying to recover the FIM from backup. I rejoined all the data between FIM and ADMA. Now I want to perform the Export operation. Because of the large amount of the transaction logs and limited disk space, the questions above occur.

All you should need to do is stop FIM, start SQL in single user mode, connect, and shrink the file.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

I'm trying to recover the FIM from backup. I rejoined all the data between FIM and ADMA. Now I want to perform the Export operation. Because of the large amount of the transaction logs and limited disk space, the questions above occur.

All you should need to do is stop FIM, start SQL in single user mode, connect, and shrink the file.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

At the moment I'm exporting the data with limit (20000 records. the total records count is ~60000). Can I stop the FIM srvice (the export process is not finished). Can I stop FIM now, restart SQL / Shrink DB and continue to export data? If I understand correctly if I start the export after the FIM service is restarted the FIM start the export from benining (not from the data which was exported when I stop FIM service). Please help me to understand it. Thanks!

I would stop the run then stop the service...My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

At the moment I'm exporting the data with limit (20000 records. the total records count is ~60000). Can I stop the FIM srvice (the export process is not finished). Can I stop FIM now, restart SQL / Shrink DB and continue to export data? If I understand correctly if I start the export after the FIM service is restarted the FIM start the export from benining (not from the data which was exported when I stop FIM service). Please help me to understand it. Thanks!

I would stop the run then stop the service...My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

ok, but what will hapened with exported data - the export will continue from the place where the process was finished after I start FIm service and I run the export profile?

Yes.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com

ok, but what will hapened with exported data - the export will continue from the place where the process was finished after I start FIm service and I run the export profile?

Yes.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com