August 20, 2004 at 11:32 pm
Friends,
I transferred multiple tables from one database to another using DTS. A table got overwritten with the new data. The problem is I did it by mistake and want to restore the table with the old data. The data in the other tables are fine. I want only one tables' data back. Can you please let me know the solution.
Regards,
Sekhar
August 23, 2004 at 6:53 am
Unfortunately you will need to restore to the point before you made the mistake from backup to another database then import the right data back in. Make sure you change the restore file names and do not overwirte your files. And make a backup before to another location for extra safety before doing this. Make sure you keep your TL file intact thou in a TL backup just in case you need to restore to a point after you last full or differential backup.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply