Home Forums SQL Server 2005 Backups Database recovery after truncate command RE: Database recovery after truncate command

  • Find the most recent backup prior to the truncate.

    Restore the database temporarily with a different name, such as "ProductionDB_20130115Backup" to identify what it is.

    Copy the table from ProductionDB_20130115Backup to ProductionDB.

    When you are confident you no longer need the restored database, delete ProductionDB_20130115Backup.

    Better than nothing I would think.