Several Problems in Log Explorer

1) when the database is completely different and the log backup is used, the idle entries in the transaction log are deleted, and then Log Explorer is used to try to view the log, the system prompts no log recorders found that match the filter, wocould you like to view unfiltered data Select Yes and you will not be able to see the record. If you do not choose to delete non-active entries in the transaction log and try to view the log with Log Explorer, you can see the original log 2) modify part of the data in one of the tables. Log Explorer can be used to view logs and restore logs. 3) restore the backup. (Note: the restoration is to disconnect Log Explorer from the database or connect to other data. Otherwise, the database is in use and cannot be recovered.) After the restoration, then open Log Explorer and prompt no log recorders found that match the filter. wocould you like to view unfiltered data. If yes is selected, you cannot see the log record modified in 2, so you cannot recover it. 3) do not use the SQL backup function to back up your logs. the correct backup method is to stop the SQL Service, copy data files and log files for file backup. start the SQL service and use Log Explorer to restore data.