Recover table from database backup

Question

Recover table from database backup

SQL.AP

Hall of Fame

Points: 3244
More actions
April 1, 2015 at 9:05 pm

#306444

Hi Guys,
I've to recover data for a single table from a database backup. I could not restore full database as it is very large (~900GB).
Please suggest what would be the best and fastest approach to recover this single table from backup.
Thanks in advance.
____________________________________________________________
AP
November 20, 2020 at 12:37 pm

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1003893 More actions · Answer 1

Anshul Parmar (4/1/2015)
Hi Guys,
I've to recover data for a single table from a database backup. I could not restore full database as it is very large (~900GB).
Please suggest what would be the best and fastest approach to recover this single table from backup.
Thanks in advance.

If you can't restore the database, then you'll need a third party bit of software to read from the backup. I don't have any recommendations there, though.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 2

Idera have a tool called SQL Virtual Database, I think that should give you what you need.

It's not free but you can start a free trial https://www.idera.com/productssolutions/sqlserver/sqlvirtualdatabase

(I don't work for Idera btw)

Grant Fritchey SSC Guru Points: 398712 More actions · Answer 3

I work for Red Gate

You can use Red Gate SQL Compare[/url] and SQL Data Compare[/url] to look at the backup and retrieve just a table and it's data.

"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