recover Dropped table

Hi,
This is a dissaster.
tables are dropped from the database, which there is no transaction log (it
was set up with simple recovery mode.)
Data has never been backup.
Is there anyway that the data can be recover from those dropped table.
Thanks,
DaraDara,
If there is no transaction log, Lumigent won't help you.
If the data has never been backed up, then I have nothing else to offer you.
(If you had a backup, then you could restore it to another database and copy
the tables from the restore database back to your working database.)
Russell Fields
Crazy Idea: If ABSOLUTELY NOTHING has been done to the database since the
tables were dropped and if you are willing to pay for the help, Microsoft
might be able to root out the tables from the database structure. This is
NOT likely though.
"Dara Bunhim" <bdara@.racha.org.kh> wrote in message
news:eCQbzvtcDHA.3520@.tk2msftngp13.phx.gbl...
> Hi,
> This is a dissaster.
> tables are dropped from the database, which there is no transaction log
(it
> was set up with simple recovery mode.)
> Data has never been backup.
> Is there anyway that the data can be recover from those dropped table.
> Thanks,
> Dara
>|||Not sure if this will work. If there was a file system backup, recover data
and log files from the backup before the table was dropped and do sp_attach.
Good luck!
"Russell Fields" <rlfields@.sprynet.com> wrote in message
news:ej3axNucDHA.1532@.TK2MSFTNGP10.phx.gbl...
> Dara,
> If there is no transaction log, Lumigent won't help you.
> If the data has never been backed up, then I have nothing else to offer
you.
> (If you had a backup, then you could restore it to another database and
copy
> the tables from the restore database back to your working database.)
> Russell Fields
> Crazy Idea: If ABSOLUTELY NOTHING has been done to the database since the
> tables were dropped and if you are willing to pay for the help, Microsoft
> might be able to root out the tables from the database structure. This is
> NOT likely though.
> "Dara Bunhim" <bdara@.racha.org.kh> wrote in message
> news:eCQbzvtcDHA.3520@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > This is a dissaster.
> >
> > tables are dropped from the database, which there is no transaction log
> (it
> > was set up with simple recovery mode.)
> >
> > Data has never been backup.
> >
> > Is there anyway that the data can be recover from those dropped table.
> >
> > Thanks,
> > Dara
> >
> >
>