data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table.
Thanks in advance
Hugo
Unfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.
|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
sql

data recovery

Hello All
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table
Thanks in advanc
HugUnfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>

data recovery

Hello All,
Is there a way to restore/recover data from an earlier date if you donot hav
e a backup. The data was accidentally deleted from a table.
Thanks in advance
HugoUnfortunately, if you do not have a backup (and more importantly are using t
ransaction log backups (to be able to restore to a specific point-in-time)),
then unfortunately there is not a way to recover the database back to it's
state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a ba
ckup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>

Data loss

We have a situation in here were one of my collegue has accidently
uninstalled a Delphi app.....how will I recover data that is lost?Are
there any tools to recover the data?"andz" <anand411@.gmail.com> wrote in news:1153300202.168067.257380
@.s13g2000cwa.googlegroups.com:

> We have a situation in here were one of my collegue has accidently
> uninstalled a Delphi app.....how will I recover data that is lost?Are
> there any tools to recover the data?
What exactly is the problem regarding the data? They should still be in the
database, or does the uninstall program delete the database as well? If so,
I guess you'll have to find the latest backup, and do a restore of the
data.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Many Thanks for your reply...
Yes, the application uninstalled the dbs aswell...we have recovered
some of the tables via a recovery tool...but some tables give the
following error - corrupt table or index header while opening.
When trying to repair using paradox it comes with error number 30704 -
u have tried to use an unassigned variable.A variable must be assigned
a value before you can use it..
Andz
Ole Kristian Bang=E5s wrote:

> "andz" <anand411@.gmail.com> wrote in news:1153300202.168067.257380
> @.s13g2000cwa.googlegroups.com:
>
> What exactly is the problem regarding the data? They should still be in t=
he
> database, or does the uninstall program delete the database as well? If s=
o,
> I guess you'll have to find the latest backup, and do a restore of the
> data.
> --
> Ole Kristian Bang=E5s
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"andz" <anand411@.gmail.com> wrote in
news:1153310037.438389.188180@.m73g2000cwd.googlegroups.com:

> Many Thanks for your reply...
> Yes, the application uninstalled the dbs aswell...we have recovered
> some of the tables via a recovery tool...but some tables give the
> following error - corrupt table or index header while opening.
> When trying to repair using paradox it comes with error number 30704 -
> u have tried to use an unassigned variable.A variable must be assigned
> a value before you can use it..
You'll either need the database files (flat file backup) or some other kind
of backup, otherwise I guess there is very little you can do. (That I know
of at least).
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP

Data loss

We have a situation in here were one of my collegue has accidently
uninstalled a Delphi app.....how will I recover data that is lost?Are
there any tools to recover the data?"andz" <anand411@.gmail.com> wrote in news:1153300202.168067.257380
@.s13g2000cwa.googlegroups.com:
> We have a situation in here were one of my collegue has accidently
> uninstalled a Delphi app.....how will I recover data that is lost?Are
> there any tools to recover the data?
What exactly is the problem regarding the data? They should still be in the
database, or does the uninstall program delete the database as well? If so,
I guess you'll have to find the latest backup, and do a restore of the
data.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||Many Thanks for your reply...
Yes, the application uninstalled the dbs aswell...we have recovered
some of the tables via a recovery tool...but some tables give the
following error - corrupt table or index header while opening.
When trying to repair using paradox it comes with error number 30704 -
u have tried to use an unassigned variable.A variable must be assigned
a value before you can use it..
Andz
Ole Kristian Bang=E5s wrote:
> "andz" <anand411@.gmail.com> wrote in news:1153300202.168067.257380
> @.s13g2000cwa.googlegroups.com:
> > We have a situation in here were one of my collegue has accidently
> > uninstalled a Delphi app.....how will I recover data that is lost?Are
> > there any tools to recover the data?
> What exactly is the problem regarding the data? They should still be in t=he
> database, or does the uninstall program delete the database as well? If s=o,
> I guess you'll have to find the latest backup, and do a restore of the
> data.
> --
> Ole Kristian Bang=E5s
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP|||"andz" <anand411@.gmail.com> wrote in
news:1153310037.438389.188180@.m73g2000cwd.googlegroups.com:
> Many Thanks for your reply...
> Yes, the application uninstalled the dbs aswell...we have recovered
> some of the tables via a recovery tool...but some tables give the
> following error - corrupt table or index header while opening.
> When trying to repair using paradox it comes with error number 30704 -
> u have tried to use an unassigned variable.A variable must be assigned
> a value before you can use it..
You'll either need the database files (flat file backup) or some other kind
of backup, otherwise I guess there is very little you can do. (That I know
of at least).
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging, MCTS, MCITP