• Hi guys, thank you for the answers.

    I am not concerned about the 500GB empty file. I am concerned about the amount of committed/uncommited transaction in the log file.Let me give more advanced details on this case because I think it is very interesting.

    The log file is 500GB, but it is 99% empty, but here is the interesting part: I have 600 VLF files in the transaction log file and all of them have a status 2 (active). I thought I was crazy, how can my log file be empty and have all the VLF files marked as active? I found the reason here: https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/06/27/lazy-log-truncation-clearing-of-sql-transaction-log-vlf-status-deferred/.

    In short, my transaction log file is empty (truncated), but all VLF files are active.

    How does it effect the restore ? Will the REDO/UNDO phases go through all VLF files because they are marked as active?