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
This is something that we’ve had on our radar for some time, but haven’t been able to get it prioritized. Will definitely consider for future releases.
109 comments
-
Anonymous
commented
Not used often but when needed, it'd be tremendously helpful.
-
Noam Graizer
commented
and also very useful is to backup a specific table or a list of tables.
-
Ademir Passos
commented
Absolutely useful! :)
-
John
commented
Yes, very usefull, especially when database sizes are in the TB size, but the table has 18K rows in it. Even if it was restored to a new object and could replace the existing object. we just need to get the table and or data back depending on the change. could potentially say hours of work and days of lost data.
-
Wim Mulder
commented
Yes, really very usefull. Oracle can do this even with where clauses, so you don't have to restore tha table completlyif you just have delete some rows per accident!
-
Gerald Britton
commented
Since backups are by page, not object, the only way to do this is restore the entire backup to a new database then copy the tables you want back to the original database
-
Amirhossin
commented
Good idea
-
Anonymous
commented
That would be wonderful to have that feature!!
-
Anonymous
commented
Under review! wow!!! Oracle had such capability for well over a decade!
-
Dany
commented
Redgate can't read compressed backup's
https://documentation.red-gate.com/sdc12/working-with-other-data-sources/working-with-backups -
Wim Buyens
commented
I think with the Redgate Toolbelt u can do this. Because u can also compare from a database with a backup. Redgate has really great tools.. I would look there https://www.red-gate.com/products/
-
Jose C Ortiz
commented
is there any update on this? we've been in pain because this feature is not on SQL server. sometimes having to restore databases with TB of data to only restore few rows-
-
Andy Steinke
commented
I feel like the System 36/38/AS400 has had this for about as long as I've been alive (if we include the skunkworks time developing S/36)...Not every database is a wonderfully elegant overengineered with perfect integrity masterpiece.
Third party options in my past have been far less than performant, often requiring scanning a full backup and the scanning it again to retrieve the table. Is this really something that needs to be left to partners or can it be considered somewhat core functionality? In the real world, "restore full database" is not the base unit of restore. Thanks!
-
Anonymous
commented
This concept already exists in LiteSpeed called object restore
-
Rezwan M
commented
Yes, we need it ,MS team should address this.
-
Eddie Panther
commented
Too many restores to only get the data from one table. Long overdue.
-
Anonymous
commented
This would be a great feature and would bring some ease in DBA lives
-
Ajay Dwivedi
commented
Definitely required
-
Ioannis
commented
absolutely yes
-
randyhartwig
commented
Long overdue.