Home Forums SQL Server 2005 Backups How do you restore a deleted record/s directly from the SQL transaction log? RE: How do you restore a deleted record/s directly from the SQL transaction log?

  • April 4, 2014 at 11:33 am

    #1703389

    ray santalis-466762 (4/4/2014)

    Hi Shawn, there is no way to restore a record directly from the transaction log? That is too bad, I have a huge database and I do not have the room on my drive to create a duplicate database. I would think that Microsoft SQL team would have some provision (TSQL system stored procedure) that would allow a simple operation like this.

    What you think is a simple operation really is not. The transaction log isn't meant to be used the way you are attempting to use it. In addition, the VLF's get flagged as inactive when it does not have any active transactions.