Restore a table
-
We have a very large database. Accidentally some data in a table is deleted. Restoring entire database would take hours. Is there a way to recover the data for a single table from transaction log or database backup.
Can you please give step by step instructions.
Regards,
gova -
If your backups are standard SQL Backups and you are not using third party tools the anwser "unfortunately" is NO, There is NO WAY.
Now, if you are using third party Log Tools and you have the Tlog Available you can doit from there. If you are using LiteSpeed for your backups then you can select the Table to restore too.
Really sorry if this is not what you want to hear
* Noel -
Thanks Noel.
I am going to have a long night today. I guess restore the backup to the development machine. then transfer the data is the only way. Is there an easy way to do this faster.
Regards,
gova -
if you have the Backup available and a spare system there is nothing preventing you from start that restore NOW!
That restore process is only as fast as the hardware of the system you are using for it is. Also make sure that you have the minimum load on it (nobody else in it).
I don't want to sound like a sales guy but maybe you can use this opportunity to get any of the above mentioned tools.
Good Luck!
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply