Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2010-09-20 : 06:11:19
|
| Let's say you deleted everything in a table by accident. Which backup strategy would fit to get most recent data for that table? I was thinking about doing transactional backups in addition to full backups but how is it possible to get data back only for that table and leave the other tables intact? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-20 : 06:14:25
|
| Restore to new, temp, database (using STOP AT if you want to restore to just-before the delete, obviously for a non-changing table restoring to an earlier time will reduce the number of TLog backups you need to restore).Then INSERT the rows back into the original database, and drop the Temporary database. |
 |
|
|
|
|
|
Backup strategy for deletes