SQL Server 2000 - Restore a single table using database backup  
Author Message
ManojKSrivastava





PostPosted: Tue Jul 18 13:47:23 CDT 2006 Top

SQL Server >> SQL Server 2000 - Restore a single table using database backup

Using SQL Server 2000, is it possible to restore a single table using a
database backup without having to restore the backup to a dummy
database and then copying the data from the table?

SQL Server172  
 
 
Tracy





PostPosted: Tue Jul 18 13:47:23 CDT 2006 Top

SQL Server >> SQL Server 2000 - Restore a single table using database backup
> Using SQL Server 2000, is it possible to restore a single table using a
> database backup without having to restore the backup to a dummy
> database and then copying the data from the table?
>

Nope, no can do...


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
 
 
Patricia





PostPosted: Tue Jul 18 14:00:49 CDT 2006 Top

SQL Server >> SQL Server 2000 - Restore a single table using database backup


> > Using SQL Server 2000, is it possible to restore a single table using a
> > database backup without having to restore the backup to a dummy
> > database and then copying the data from the table?
> >
>
> Nope, no can do...
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

I didn't think so since I could not find anything on it but it is
always nice to have a confirmation. Thanks so much for your reply.

 
 
Tom





PostPosted: Tue Jul 18 13:58:50 CDT 2006 Top

SQL Server >> SQL Server 2000 - Restore a single table using database backup With prior planning, yes. You could create a filegroup with a single file.
Create the table - and nothing else - in that one filegroup. Backup the DB.
Now, you can restore the filegroup from the backup.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.


Using SQL Server 2000, is it possible to restore a single table using a
database backup without having to restore the backup to a dummy
database and then copying the data from the table?