July 24, 2008 at 5:43 am
How do recover the dropped tables and records
July 24, 2008 at 7:02 am
Restore from your most recent backup, into a new database and copy over the dropped rows/tables.
July 24, 2008 at 7:15 am
Thanks for reply.
if i restore the recent backup , today transaction data is loss.
July 24, 2008 at 7:47 am
Then you have to restore to a new location, either a new database or a new server, and then move the data you need to recover from that new location to the original database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply