Recover data log loss

  • norleeza23

    Valued Member

    Points: 62

    Hi. I would like to know is it possible to recover data log table from SQL Server 2014 without backup file?

  • anthony.green

    SSC Guru

    Points: 112480

    Any form of recovery will need a backup.

     

    The caveat would be if your in FULL recovery and have not backed up the transaction log after the point in time you want to recover, you could then read the active portions of the log and find out what happened.

     

    But 99.999999% of the time, you need backups

  • Grant Fritchey

    SSC Guru

    Points: 396614

    Piling on because this bears repeating.

    Yes, in order to do recovery you need backups. Further, in order to ensure your backups are good, you need to test them regularly. The single best test is a restore of that backup. You should have backups and backup testing set up on your systems and completely automated. If you don't have it, that's your very first task at work today.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply