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

Jan 11 '06 #1

Subscribe Reply

2335

Greg D. Moore \(Strider\)

"bd420" <bd***@hotmail. com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.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

Jan 11 '06 #2

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****@sommarsk og.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

Jan 11 '06 #3

Similar topics

2814

recover deleted records from backup, best approach?

by: DaveDiego | last post by:

I've had a user delete one of the client records, I do have a version of the DB with all records intact before the deletion occured. Whats the best approach to getting all the related records in each of the tables? I have about 12 tables to put data back into and multiple records for each. Would I need to make an append or update query for each table?

Microsoft Access / VBA

29016

recover deleted records

by: Grant | last post by:

Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis

Microsoft Access / VBA

7629

HELP: how to recover deleted record from a Table

by: Roberto La Forgia | last post by:

Hi all, there is a utility o procedure to recovery deleted record from a Access table (versione 2002/2003) ? Thanks in advance Roberto

Microsoft Access / VBA

12574

How to recover deleted rows

by: senthiltsj | last post by:

hi two days before arount 20,000 rows are manuly deleted, is there any way to recover it back. We have backup, that is 10 days old, Is there any way to recover only that 20,000 rows, Plz help me out ASAP. Regards Senthil Kumar.T

MySQL Database

11483

Recover deleted rows from a table from archive logs?

by: Snonck | last post by:

Is is possible to recover deleted rows from a table from archive logs? For example, say you have a database with archive logging turned off. You create a table and populate it with records. You then reset the logs and place the database in archivelog mode. Then you delete from table;

Oracle Database

9499

How to recover deleted records mysql when using phpmyadmin

by: Astlik | last post by:

Hi, I was using phpmyadmin when, by mistake I deleted some rows from a table I didn't wanted to. I would like to know if anyone could help me recovering those records I deleted. I don't have any backup file and I don't know how to do it. Can it be done without a backup file? Hoping for a quick answer. Many thanks Diana Guimarães

MySQL Database

2972

how to if needed recover from mistake

by: Jeff Kish | last post by:

Hi. I deleted a stored procedure (one I had written) out of the master database. I thought I had accidentally put it there, then I got to thinking.. what if it is normally reflected there, and maybe I should not of deleted it. So.. my question.. is it normal for procedures in other databases to be reflected also in the master database, and then how can I restore / recover the master database if necessary. I am using sql server 2005 on...

Microsoft SQL Server

24956

How to recover deleted records?

by: nano2k | last post by:

Hello I accidentaly ran a DELETE command against a table with a wrong WHERE clause. My database had no backup, but the recovery model was Full. I am using SQL Server 2005. Is there a way, or any utility software that could help me recover the lost data? The .ldf file is twice as big than the .mdf file, so I think that my

Microsoft SQL Server

7786

RECOVER inadvertently deleted table from mdb?

by: MLH | last post by:

Utilities to recover tbl removed from TABLE tab of database window with the DELETE key?

Microsoft Access / VBA

3816

how recover deleted records from a acess database?

by: Jason7899 | last post by:

hi, there is any way to recover deleted records from a acess database? thanks a lot for your help )

Microsoft Windows

10439

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10215

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10165

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9043

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6783

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5437

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3727

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2920

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General