Restore a table from a backup
Hi Msft team!
I'm writing to reccomending a new feature that will help us a lot! Every time that we have data issues (truncate or DML by accident) we need to restore the entire database or filegroup and that takes a lot of time! it will be awesome if you can add the posibility to restore a table from a backup or restore to a point in time directly from SSMS instead off the whole process.
I hope this helps!
Thank you!
Gonzalo Bissio
shared this idea
89 comments
-
Bill
commented
There are challenges/problems with restoring a table. RI gets blown away. Triggers are't undone. More generally, changes to other tables (that are based upon changes to the table that is being restored) will remain in place (whether the modifications were done in the same transaction that modified the table that is being restored, or as commonly done in a different transaction at some later time). SQL Server 6.5 allowed table restores. It was a slick way to replace a corrupted table with a clean one. But one consequence was that table restores created all sorts of **** with applications. Perhaps allow it when a ALLOW_LOGICAL_INCONSISTENCIES clause is passed. Of course, that clause will cause customer's to say "But, I don't wan't logical inconsistencies!" Caveat emptor!
-
Jeff Moden
commented
In a Development or Testing environment, it can happen a lot, Pete. But even if that's not important to some (and it is important), it only takes once on a 24/7 large database to have a real appreciation for such a feature.
-
Pete
commented
funny - it appears you have a lot of "accidents"
-
Alina
commented
Yes !!
-
Sam76
commented
Completely agree, thank you Chrissy for addressing this issue.
-
Chrissy LeMaire
commented
triple yes
-
Amadou Barry
commented
This will be very good feature to have.
-
Robin Wilson
commented
This would be so helpful. Better than having to restore the entire multi-GB database elsewhere and then have to write a script to do this when the table in question may be tiny.
Would need consideration on how to handle issues with database constraints though. -
Blaise Gachet
commented
Should be part of a backup/restore handling.
-
Luv
commented
When other vendors can provide this then this should also be in SSMS.
-
JORGEPEREZUY
commented
Yes, it is very important, MS team should address this.
-
rob woods
commented
Yes, I'd like to have this back. I believe we could do this in version 5 or 6.
-
Daniel
commented
Yes, it is very important, MS team should address this.
-
u
commented
What the heck? Why don't they want to add this? This is really important! What do they do on their sits?
-
Fernando Jacinto Alvarez
commented
you can use https://solutioncenter.apexsql.com/restore-objects-from-sql-backup-into-test-database/ meanwhile we wait for this.
-
GUN10
commented
selective recovery actions has been a "dba-workaround-task" for decades. We need it Out-of-the-box!
-
Anonymous
commented
Yes, Double yes.
-
Anonymous
commented
Single table backup and restore feature was there in SQL server 7 which was so useful. I wish Microsoft had not dropped this useful feature from SQL Server 2000 on wards.
-
Anonymous
commented
MS. Although this feature is available from other companies, the reliability of the restore for large tables; 500 GB compressed; is low.
-
Vlad Kirov
commented
it must be done as it is possible through the litespeed