June 10, 2016 at 4:38 am
Hi,
I have a 5TB database and one of my customer accidentally deleted a table. I have EMC backup running in for this database, but to restore back it may take hours where I don't wanted to wait as its LIVE server. Is there any other way to recover this table faster. Generally does SQL Server has any other options just incase if a table is deleted from a huge database in size ?
Regards,
NM
June 10, 2016 at 6:32 am
I don't think SQL has something like Oracle's FLASHBACK Table. I know of 3rd party products that claim to have this ability
June 10, 2016 at 7:06 am
Although this doesn't answer your question, why does a customer have the ability to delete a table? If this is something they definitely shouldn't be doing, it most definitely worth reviewing the database permissions, otherwise "I accidentally deleted a table" could turn into "I accidentally deleted everything".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 10, 2016 at 7:22 am
You can try some of the 3rd party tools that allow you to attach database backups and work with them as with live databases. You can try SQL Virtual Restore from Red Gate or ApexSQL Restore from ApexSQL or SQL Virtual Database from Idera
June 10, 2016 at 9:30 am
gfoxxy93 (6/10/2016)
You can try SQL Virtual Restore from Red Gate
Retired in 2015, unfortunately - see http://www.red-gate.com/products/dba/sql-virtual-restore/
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply