October 22, 2009 at 10:15 pm
Hi All
My strange requirement is I want to restore selected tables from my .bak file to existing database (SQL-Server 2005)
My concerns :-
Is it possible to just restore the tables I specify from a .bak file?
If so
a)Some tables have no foreign key relationships but some do.
b)1 of the table has lots of indexes and lots of data
Cheers
October 22, 2009 at 10:40 pm
Unfortunately the only way to backup a single table from a backup is if you had it put on a separate filegroup and restore that
October 22, 2009 at 11:15 pm
sqlcool,
It is not possible.
The work around is restore the backup with different db name. Do BCP / DTS to recover data to original table.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply