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
76 comments
-
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
-
Anonymous
commented
Yes would be awesome to have!
-
Anonymous
commented
Yes
-
Jorge Guillen
commented
Yes please!, it would be a great help for us dbas
-
Andrew Burrow
commented
Yes please!
-
Anonymous
commented
Yes this is now a day's getting very important in daily life of DBA when you have 5 tb database and you need to restore only 1 table and you can't and finally you have to restore the whole database
-
Anonymous
commented
YES
-
Lance R.
commented
yes!
-
rommel
commented
Yes Please!
-
Anonymous
commented
Please!
-
Jason Rowland
commented
I would like to see this feature.
-
Chris
commented
Yes! 3rd party backup tools like Litespeed have offered this for a while, Microsoft step up to the plate and support this natively, just like you did with Compression years ago. We already pay a hefty license, quit making us buy 3rd party licensing to have a single feature which should be included natively.
-
Steve Sullivan
commented
This would be a huge game changer for the Admin and Developer teams. Time, cost and ROI savings! Yes, please!
-
Keith Brockman
commented
The ability to restore at the table level and restore just all the DDL statements with no rows has existed in Oracle for over a decade. My point being if Oracle export/import has this capability, it shows that Microsoft could step up to the plate and "make it so" with backup/restore. Who knows it may be a great tool for moving more people from Oracle to SQL Server.