MS SQL Server - Recover Data

Author

Recover Data

Mestre

2006-02-06, 7:23 am

Hi,

Is it possible to recover data from a log file? I don't have any backups, i
only have a database in SQL 2000 with recovery model full, and i need to
recover some data from two tables? is there a way of do it?

Thanks in advance,
Mestre

Jens

2006-02-06, 7:23 am

Unless you use a log recovery tool, there is no way to do so.

HTH, jens Suessmeyer.

Mestre

2006-02-06, 7:23 am

Hi Jens,

Can you advise some of them.

Thanks
Mestre

"Jens" <Jens@sqlserver2005.de> wrote in message
news:1139226893.465251.291980@g47g2000cwa.googlegroups.com...
> Unless you use a log recovery tool, there is no way to do so.
>
> HTH, jens Suessmeyer.
>

Sreejith G

2006-02-06, 7:23 am

Below are few Log Reader tools.

Apex SQL Log
Log Explorer
Log P.I.
SQL Log Rescue

http://aspfaq.com/show.asp?id=2449

Log Explorer is simple one to use.

Thanks,
Sree

"Mestre" wrote:

> Hi Jens,
>
> Can you advise some of them.
>
> Thanks
> Mestre
>
> "Jens" <Jens@sqlserver2005.de> wrote in message
> news:1139226893.465251.291980@g47g2000cwa.googlegroups.com...
>
>
>

Mestre

2006-02-06, 11:23 am

thanks

"Sreejith G" < SreejithG@discussion
s.microsoft.com> wrote in message
news:02C748C5-617E-454E-9811- 5A820CBF37FB@microso
ft.com...[color=darkred]
> Below are few Log Reader tools.
>
> Apex SQL Log
> Log Explorer
> Log P.I.
> SQL Log Rescue
>
> http://aspfaq.com/show.asp?id=2449
>
> Log Explorer is simple one to use.
>
> Thanks,
> Sree
>
>
> "Mestre" wrote:
>

Sponsored Links