![]() ![]() ![]() Reverse inadvertent or malicious database changes that occurred even before the product was installed. Read the transaction log to find out who created, changed or dropped a database object. Determine who changed data and when the change occurred. ApexSQL Log reads SQL Server 2005 ,2008, 20 transaction logs. In closing, you can use Apex SQL Log when you need to read SQL Server database transaction logs to find out exactly who performed the actions in a specified period of time and recover lost or damaged data effortlessly.ApexSQL Log, SQL Server Transaction Log reader, lets you view transaction log data, audit SQL database changes and undo SQL database changes. The right click menu allows you to export the checked entries to CSV, HTML, XML or SQL format, create undo or redo scripts and copy specific rows to clipboard. You can either open the results in a grid format, export them to a specified file format or simply create batch files. The application provides you with three options in order to store the generated information. After that, Apex SQL Log will automatically generate a log file that contains all the details related to database actions.Īdditionally, you can filter your searches by time range, by operations such as alter, create or drop, or simply by tables. Since it works smoothly with SQL Server, the application requires you to specify the server that needs to connect to, then choose the authentication mode and the database you want to inspect. This way, you can read the transaction log for the current database and view all the information you need to establish which user created, changed or dropped a database object. Using Apex SQL Log you are able to determine who changed data and when the change occurred. For instance, if a user modifies the primary key of a table, the other child tables that are connected through a primary key will not work anymore. Working with multiple databases and granting read / write permissions to various users might affect your SQL data and some of the connected tables will not work properly anymore. ![]() Apex SQL Log is a reliable and useful software solution that comes in handy for database administrators who need to audit data, schema and tables, as well as rollback database changes and recover missing or damaged data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |