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!
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.
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! :)
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
That would be wonderful to have that feature!!
Under review! wow!!! Oracle had such capability for well over a decade!
Redgate can't read compressed backup's
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!
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.
This would be a great feature and would bring some ease in DBA lives
Ajay Dwivedi commented