There is so many blog posts and articles out there about this case and I have been reading, but I am still confused. I restored a database and it took more than 12+ hours to complete. I noticed that the transaction log was more than 500GB, so I am guessing the redo/undo phase was very long. Database is in full recovery mode.
If the transaction log is 500GB, but its has 490GB of free space. Does it mean that I have only 10GB of committed/uncommitted transactions?
If the transaction log is 500GB and it has no free space, does it mean that I have a lot of committed/uncommitted transactions in the log file? If yes, should I just take a backup of the transaction log to clear the committed/uncommitted transactions ? And then take a full backup.