Can LOG PI or Log Explorer recover deleted records BEFORE

[bd420]

installation of their softwares? If there has NEVER been a backup of
the Database (.mdf), Recovery Model Set to Full, and there has never
been a backup of the Log (.ldf) files?

Using the trial software for both, this was unclear.

Thank you for your time,

bd

[Greg D. Moore \(Strider\)]

"bd420" <bd***@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

installation of their softwares? If there has NEVER been a backup of
the Database (.mdf), Recovery Model Set to Full, and there has never
been a backup of the Log (.ldf) files?
My understanding is that as long as you have NOT truncated your log file the
answer should be yes.


Using the trial software for both, this was unclear.

Thank you for your time,

bd

[Erland Sommarskog]

bd420 (bd***@hotmail.com) writes:

installation of their softwares? If there has NEVER been a backup of
the Database (.mdf), Recovery Model Set to Full, and there has never
been a backup of the Log (.ldf) files?

Using the trial software for both, this was unclear.

I believe the answer is no. The key here is that you have never taken a
backup of the database. As long as you have done that, the log works as
if you were in simple recovery. After, a log is supposed to be applied
to a database back, so if there isn't any...

But hadn't it been for this fine detail, the answer would be yes. That
is, there is a full backup taken some time, and you are running in
full recovery.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx