Community
Showing results for 
Search instead for 
Do you mean 
Reply

database alf file got to 60gb over night

Accepted Solution Solved
Astute Commentator
Posts: 14
Country: Israel
Accepted Solution

database alf file got to 60gb over night

i don't remember the exact size it was before

but it wasn't event close to that

 

ideas?


Accepted Solutions
Solution
Accepted by topic author liorme
‎06-09-2017 11:56 PM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: database alf file got to 60gb over night

Hi liorme,

 

This could be a sign of an issue with your database. It should never become this large. 

 

How large is your .adf file?

 

The first step in troubleshooting this issue is recreating the .alf file by following these steps:

  1. Ensure nobody else is logged into the database
  2. Fully back up your database.
  3. Using ActDiag, detach your database from SQL.
  4. Rename the .alf file to .alfOLD.
  5. Using ActDiag, attach your database to SQL using only the .adf.
  6. Use Act! as normal and monitor the size of the .alf

If it increases again, we'll need to do some further investigations.

View solution in original post


All Replies
Solution
Accepted by topic author liorme
‎06-09-2017 11:56 PM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: database alf file got to 60gb over night

Hi liorme,

 

This could be a sign of an issue with your database. It should never become this large. 

 

How large is your .adf file?

 

The first step in troubleshooting this issue is recreating the .alf file by following these steps:

  1. Ensure nobody else is logged into the database
  2. Fully back up your database.
  3. Using ActDiag, detach your database from SQL.
  4. Rename the .alf file to .alfOLD.
  5. Using ActDiag, attach your database to SQL using only the .adf.
  6. Use Act! as normal and monitor the size of the .alf

If it increases again, we'll need to do some further investigations.

Astute Commentator
Posts: 14
Country: Israel

Re: database alf file got to 60gb over night

thank you
is it allowed to change the alf? no harm will come to my adf? (adf size about 400mb)
what's the purpose of the file?
Administrator
Posts: 4,024
Country: United_Kingdom

Re: database alf file got to 60gb over night

Hi liorme,

Under normal circumstances, the .alf should not be edited by users.
Taking a backup before making any changes will protect your database should anything go wrong.
The .alf file is the transaction log file, which stores changes to the database, and should then be emptied once completed. This clearly isn't happening correctly right now.
Astute Commentator
Posts: 14
Country: Israel

Re: database alf file got to 60gb over night

thank you

i'll backup and give it a try