Rollback the sql server data Is it possible to restore the rollback changes to a database? One of my client has done wrong updates on database so most of the tables have been updated with wrong data.
That database is having with Replication, So can anyone suggest me without or less downtime can i restore the database with last 2days of data. Thanks in advance
It is possible to rollback wrong updates without any downtime using ApexSQL Log. For maximal UPDATE reconstruction, the database should be in the Full recovery model, and a full chain of transaction logs is needed.

A full chain of transaction logs starts with a full database backup and is followed by all subsequent transaction log backups up to a point of the rollback.



How to recover SQL Server data from accidental UPDATE and DELETE operations 

How to recover SQL Server data from accidental updates without backups 

Disclaimer: I work for ApexSQL as a Support engineer