Move the database transaction log to another drive

Locating the transaction log for the MicrosoftIdentityIntegrationServer database on a drive that is separate from the database can improve performance and reliability. By default, when you install Microsoft Identity Integration Server 2003, the transaction log and the database are located on the same drive.

For this procedure, you can use SQL Server Enterprise Manager to move the database transaction log to another drive. To complete this procedure, you must be logged on as a member of the MIISAdmins security group.

To move the database transaction log to another drive

1. Click Start, point to Administrative Tools, and then click Services.
2. In Services, right-click Microsoft Identity Integration Server, and then click Stop.
3. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
4. In the console tree, click the MicrosoftIdentityIntegrationServer database.

   Where?

   • Console Root
   • Microsoft SQL Servers
   • SQL Server Group
   • (local)(Windows NT)
   • Databases
   • MicrosoftIdentityIntegrationServer
5. On the Action menu, point to All Tasks, and then click Detach Database.
6. In Detach Database - Microsoft Identity Integration Server 2003, select the Update statistics prior to detach check box, and then click OK.
7. Click Start, point to All Programs, point to Accessories, and then click Windows Explorer.
8. In Windows Explorer, click the Microsoft Identity Integration Manager_Log file. By default, the log file is in the C:\Program Files\Microsoft Identity Integration Server\Data folder.
9. On the Edit menu, click Move to Folder.
10. In Move Items, select a new location for the log file on a separate drive, and then click Move.
11. In SQL Server Enterprise Manager, click the Databases folder.

    Where?

    • Console Root
    • Microsoft SQL Servers
    • SQL Server Group
    • (local)(Windows NT)
    • Databases
12. On the Action menu, point to All Tasks, and then click Attach Database.
13. In Attach Database - (local), in MDF file of database to attach, browse to and select the Microsoft Identity Integration Manager_Data.mdf file. By default, the MDF data file is in the C:\Program Files\Microsoft Identity Integration Server\Data folder.
14. In Original File Names(s), click Microsoft Identity Integration Manager_Log.LDF (a red X indicates an invalid path), and then in Current File(s) Location, type the path for the new location of the Microsoft Identity Integration Manager_Log file. (The red X changes to a green check, indicating a valid path.)
15. In Attach as, verify that MicrosoftIdentityIntegrationServer is entered. In Specify database owner, verify the database account that Microsoft Identity Integration Server 2003 uses, and then click OK.
16. Click Start, point to Administrative Tools, and then click Services.
17. In Services, right-click Microsoft Identity Integration Server, and then click Start.

Important

• It is strongly recommended that you back up Microsoft Identity Integration Server 2003 before moving the transaction log. For more information, see Related Topics.
• It is strongly recommended that you secure the Microsoft Identity Integration Manager_Log.LDF file in its new location with the same Grant Access permissions as the Microsoft Identity Integration Manager_Data.mdf file.

Related Topics

Backing up Microsoft Identity Integration Server 2003

Stop and restart the Microsoft Identity Integration Server service

Best practices for security