Home Forums SQL Server 2005 Administering Recover data from TRUNCATE RE: Recover data from TRUNCATE
Greg Charles
SSC-Forever
Points: 45403
More actions
March 9, 2011 at 12:12 pm
#1296702
Basically, you would restore a backup to a new database and copy the table and data back into the original database.
How you do the restore depends on the database's recovery model and what kind of backups you've made.
Greg