SQL Server : Does Apex Log reader miss to track any Transaction while SQL Transaction log backup running.

Hi Team,

We want to implement audit solution in my company.We are looking Apex log read.

My doubt:  In SQL server:  if we take transaction log backup , the transaction log information gets truncated from the transaction log file. in that case if we are using Apex Log Reader (to read online transaction log) will miss any records? 

Please advice 

Parents
  •  Hi dastagiri16,

    If you want to audit your databases or even your servers, the best tool for this task is ApexSQL Audit.

    Whereas ApexSQL Log is a tool to replicate and/or rollback changes on lost data and can also audit some information from the transactional data, it cannot handle data tampering and other maleficent actions should there be any, ApexSQL Audit does this best.

    Here's a video explaining what ApexSQL Audit is and what it does: Introduction to ApexSQL Audit

    To know more about our tool, please follow this link: ApexSQL Audit Getting Started

    You can download the trial version here: ApexSQL Audit Trial Download

    Hope this information is helpful, last but not least feel free to open a Service Request if you need to clarify any inquiries or concerns, our support team will always be happy to help.

    Best Regards,

    Armando

Reply
  •  Hi dastagiri16,

    If you want to audit your databases or even your servers, the best tool for this task is ApexSQL Audit.

    Whereas ApexSQL Log is a tool to replicate and/or rollback changes on lost data and can also audit some information from the transactional data, it cannot handle data tampering and other maleficent actions should there be any, ApexSQL Audit does this best.

    Here's a video explaining what ApexSQL Audit is and what it does: Introduction to ApexSQL Audit

    To know more about our tool, please follow this link: ApexSQL Audit Getting Started

    You can download the trial version here: ApexSQL Audit Trial Download

    Hope this information is helpful, last but not least feel free to open a Service Request if you need to clarify any inquiries or concerns, our support team will always be happy to help.

    Best Regards,

    Armando

Children
No Data