Extracting a table from a dbbackup possible?

Hi there,
A poweruser dropped a table in production(don't ask me why he got
authorization to do that!). So I would restore the backup to a new,
temporary db to extract this table. However, the server lacks diskspace
for another 28 Gb db. This will be remedied in the near future, but
right now I have no room to restore this backup. Is there a way to
extract just 1 table from a backupdevice? I could not find anything via
google sofar, so I doubt it; still, anyone has a solution?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!There is no way to extract a single table from a backup. You must restore
the backup first. I am afraid you will need to find the space somewhere to
restore to.
--
Andrew J. Kelly SQL MVP
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Lumigent Log Explorer can help with this if you have the logs of when the
table was dropped.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"hansje" <hansjes@.anonymous.com> wrote in message
news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> A poweruser dropped a table in production(don't ask me why he got
> authorization to do that!). So I would restore the backup to a new,
> temporary db to extract this table. However, the server lacks diskspace
> for another 28 Gb db. This will be remedied in the near future, but
> right now I have no room to restore this backup. Is there a way to
> extract just 1 table from a backupdevice? I could not find anything via
> google sofar, so I doubt it; still, anyone has a solution?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Good point Ray...
--
Andrew J. Kelly SQL MVP
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> Lumigent Log Explorer can help with this if you have the logs of when the
> table was dropped.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "hansje" <hansjes@.anonymous.com> wrote in message
> news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > Hi there,
> >
> > A poweruser dropped a table in production(don't ask me why he got
> > authorization to do that!). So I would restore the backup to a new,
> > temporary db to extract this table. However, the server lacks diskspace
> > for another 28 Gb db. This will be remedied in the near future, but
> > right now I have no room to restore this backup. Is there a way to
> > extract just 1 table from a backupdevice? I could not find anything via
> > google sofar, so I doubt it; still, anyone has a solution?
> >
> > Tnx,
> >
> > Hans Brouwer
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>|||Yep!, there were problems with undoing DDL commands in regards to tables in
Log Explorer but the latest version is supposed to have fixed that.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:%23lUiIkPtDHA.424@.TK2MSFTNGP11.phx.gbl...
> Good point Ray...
> --
> Andrew J. Kelly SQL MVP
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:ObdQdfPtDHA.2932@.TK2MSFTNGP11.phx.gbl...
> > Lumigent Log Explorer can help with this if you have the logs of when
the
> > table was dropped.
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "hansje" <hansjes@.anonymous.com> wrote in message
> > news:eG8OjMPtDHA.2348@.TK2MSFTNGP09.phx.gbl...
> > > Hi there,
> > >
> > > A poweruser dropped a table in production(don't ask me why he got
> > > authorization to do that!). So I would restore the backup to a new,
> > > temporary db to extract this table. However, the server lacks
diskspace
> > > for another 28 Gb db. This will be remedied in the near future, but
> > > right now I have no room to restore this backup. Is there a way to
> > > extract just 1 table from a backupdevice? I could not find anything
via
> > > google sofar, so I doubt it; still, anyone has a solution?
> > >
> > > Tnx,
> > >
> > > Hans Brouwer
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>