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

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.sqlmonster.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 backup ?
>kindly advise
>tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1|||Such a restore has to be done into a new database, and using the PARTIAL option of the RESTORE
command. There are other restrictions as well, see the RESTORE command and the PARTICL option in
Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message news:5fb1558785963@.uwe...
> 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 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 backup ?
>>kindly advise
>>tks & rdgs
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-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 as
the whole db is quite huge
Paul Ibison wrote:
>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)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1

Restore Problem (6.5)

I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
don't have enought disk space, so work has kindly provided a USB external
hard disk. I can create the device on that disk, but what I try and restore
the database. It comes up with a 'Unable to write to server-side connection'
error message.
Any ideas ?
Cheers
MarkHi,
After creating the device , did you tried creating the database. The size
should be identical to the source database from where you received the dump
file.
Give me more information about,
1. Location of Dump file
2. Are you able to see the logical drives (newly attached external disk)
from explorer?
If you still have issues , try creating a table on the new database created.
Thanks
Hari.
MCDBA
"Flems" <Mark.Flemans@.apakgroup.com> wrote in message
news:uLYdnMXvDHA.1788@.tk2msftngp13.phx.gbl...
> I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
> don't have enought disk space, so work has kindly provided a USB external
> hard disk. I can create the device on that disk, but what I try and
restore
> the database. It comes up with a 'Unable to write to server-side
connection'
> error message.
> Any ideas ?
> Cheers
> Mark
>