restore single table

Hi All ,
Is it possible to restore just a single table from a particulare db's backup
?
kindly advise
tks & rdgs
Message posted via http://www.droptable.comHi ,
I believe i can put that particular table into its own file group and
therefore, if i restore using file group i am just restoring that particular
table
am i correct on the above ?
and is thre anyother solution to this ?
tks & rdgs
maxzsim wrote:
>Hi All ,
>Is it possible to restore just a single table from a particulare db's backu
p ?
>kindly advise
>tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1|||Such a restore has to be done into a new database, and using the PARTIAL opt
ion of the RESTORE
command. There are other restrictions as well, see the RESTORE command and t
he PARTICL option in
Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via droptable.com" <u14644@.uwe> wrote in message news:5fb1558785963@.uwe...eagreen">
> Hi ,
> I believe i can put that particular table into its own file group and
> therefore, if i restore using file group i am just restoring that particul
ar
> table
> am i correct on the above ?
> and is thre anyother solution to this ?
> tks & rdgs
> maxzsim wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200605/1|||Alternatively you could restore the entire database to a database of another
name then use TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp) or Redgate's
Datacompare to create the synchronization script.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||tks ppl . basically i want to backup/restore certain important table fast a
s
the whole db is quite huge
Paul Ibison wrote:
>Alternatively you could restore the entire database to a database of anothe
r
>name then use TABLEDIFF
>(http://www.replicationanswers.com/TableDiff2005.asp) or Redgate's
>Datacompare to create the synchronization script.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1