Restoring a single table

Question

Restoring a single table

san43

Hall of Fame

Points: 3196
More actions
April 4, 2007 at 11:16 am

#76683

How can we restore a single table from the backup in SQL Server 2000?

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

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

sql_er SSCarpal Tunnel Points: 4135 More actions · Answer 1

I don't think it is possible, other than restoring the whole db somewhere, and then copying the table over to wherever place you need it ...

John Rowan SSC Guru Points: 56440 More actions · Answer 2

Unless the table is in its own filegroup, you can't. You must restore the entire DB to another location and copy/move the data from the table you want to recover.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

scb SSCommitted Points: 1859 More actions · Answer 3

There are some third party tools that allow for table level restore, such as SQL Litespeed from Quest.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

Litespeed does it, since I've had smaller, GB sized dbs, I use sql_er's method. Restore on another server or a new db, copy data over.