Restoring a Single Table from Backup

Question

Post reply

Restoring a Single Table from Backup

Allan Brooks

Old Hand

Points: 358
More actions
December 12, 2014 at 3:47 am

#296022

Hi all,
With all the new functionality, can 2014 now restore a single table from a standard backup without using any third party tools? I have looked, but can't see this listed as a feature (though that doesn't mean it's not there, maybe I've just missed it).
The why's and wherefores aside, is this now possible?
Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Nope. Unfortunately this is not possible with native tools, nor I think this feature is in Microsoft's plans.

-- Gianluca Sartori

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 2

You're still stuck with third party tools for doing this type of thing.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Allan Brooks Old Hand Points: 358 More actions · Answer 3

Ok, didn't think so! Thanks for the confirmation gents!

joshdbguy SSCertifiable Points: 7707 More actions · Answer 4

Just a question, what's the reason?

You can always script out a restore to a new DB, script out the table migration (can use generate scripts to do this), and then drop the DB afterwards. I wouldn't really recommend this though as it's messy.

Allan Brooks Old Hand Points: 358 More actions · Answer 5

Thanks for the process thoughts there.

Why though? For a number of reasons really - anything from testing scripts on an isolated table/group of tables in space limited environments to quickly pulling back historical info due to business queries.

The DB's we have had to do this for in the past are all 600 GB to 2TB-ish (never the small ones).

There are a number of 3rd party apps out there that offer table restores from backup but I didn't want to go down that rout if there was native functionality.

The Oracle DBA I work with was quick to point out that he can do it on his DB’s . . .

joshdbguy SSCertifiable Points: 7707 More actions · Answer 6

Allan Brooks (12/17/2014)
The Oracle DBA I work with was quick to point out that he can do it on his DB’s . . .

Haha, I'm sure he did.