APEXSQL Log Usage Experience

Today encountered a basic data is deleted resulting in error, remote to the server, just a few days ago to recover a backup library, find that record manually plug back first solved.

Other regions also occasionally happen this situation, the data is inexplicably lost, should be mistakenly deleted. Our side of the system if there is a delete to do the log, check the log table did not find the operation, may be a colleague's system or stored procedures caused.

Found some database Tools, Log Explorer heard good, but it seems to only support to SQL2005

The new version has a call ApexSQL log can support, the official website has a trial version, the latest version is 2016.3.

Online tutorial is too little too little, occasionally a few or copy to copy, fortunately there is a master (escms wing Sail) cracked (version 2016.1, a search apexsql log there), in this expressed thanks

On my machine two can (win 10), tried a few servers (all win 2008), the official website can, cracked version of the not, has been reported that a DLL is not registered, installed the. NET Framework 4.5.2 also do not (in order to install this also the client server restarted ... ), according to Bo main message first installed the original and then run also not, installed the original after the green version covered back also not ...

Trial version of the limit is too large, only to view 1 per 10 bar, the other direct display is not available, if only can be found can not guide the same.

Automatic task truncation Log on client server every day ... So can only find the day, but strange no matter how to do, can only be found in the afternoon, the morning a business has not been done also impossible ah, even if there is no business, those automatic tasks, how much will be recorded.

Direct Bak restores back, as if not good, record very little. Finally, while off-duty no one used, the database service stopped, the MDF and LDF packaging copied back to attach.

Super powerful, can find all the records, even the update record can see before and after the update, bold marked, but also to generate a variety of scripts and various exports. Search, filter, export, are very satisfying.

Restore to this machine is possible, there is an option can be connected to the remote database, but to install a remote component. The remote component cannot be installed directly on the remote (WIN2008), and the remote installation component also fails after the native connection.

Overall is a very good tool, for ignorant me, even the only one can read the SQL Log tool, to stay in case of a rainy. Today to practice under also see their own shortcomings, usually is the ordinary additions and deletions to check, encountered backup, recovery, data processing, on the flying blind.

APEXSQL Log Usage Experience