How can I rebuild my Act! database log file in the event that it is missing or damaged?
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: 2009 and later
It is STRONGLY recommended that you ensure you have backups of your database files prior to proceeding with the steps below. Failure to do so can result in damaged and/or lost data. If you are able to open the database, you can create a backup of the database using the following knowledgebase article:
How to back up and restore an Act! database
Answer ID How to back up and restore an Act! database
If you are NOT ABLE to open your database to make a backup, you can manually copy the files to a different location to back them up by using the steps in the following knowledgebase article:
How to copy or move an Act! database without doing a backup and restore
Answer ID How to create a manual backup or copy and move an Act! database without doing a backup and restore
If your Act! database log file is missing or has become damaged, you can use Act! Diagnostics to recreate a new database log file as a .LDF file.
NOTE: You may notice that the log file for an Act! database is typically in the format .ALF. When going through the process below, you will no longer use the .ALF file, and instead will create a .LDF file. Simply put, a .LDF file is the Microsoft SQL equivalent of an Act! .ALF file. They perform the same function, and hold the same information. Your database will not lose any functionality, it will simply make use of a .LDF file rather than a .ALF file.
Follow the steps below to rebuild the Act! database log file:
- Close Act!
- On your keyboard, press the Windows key + R to bring up the Run dialog
- Type actdiag and press Enter
- If applicable, click OK on the disclaimer dialog
- Click Databases > Database List
- Find the name of your database on the list and take note of the File Path
- Click the gray box to the left of your database name to select it
- Click Actions > Detach database
- When prompted, click yes to detach your database
- Browse to the location of your database and locate (database name).ALF
NOTE: If you have already rebuilt the log file for this database in the past, then you will have a .LDF file instead. apply the same steps to the .LDF in this instance.
- Right-click and choose Rename
- Rename the file to (database name).OLD
- Go back to the Act! Diagnostics window and click Tools > Attach Act! Database > Missing Log File
- From the Attach database window, browse to the location of your database files
- Choose the .ADF for your database and click Open, then click OK
- When prompted, click Yes to attach the database
- Once the database has been attached, click OK and close out of Act! Diagnostics
- Verify that you are able to access your database