Re: Table Truncated (Urgent)

Tech-Archive recommends: Speed Up your PC by fixing your registry

Chandrasekar (sekar@xxxxxxxxxx) writes:
Hi Hari

I don't have any backups before accidential deletion of table.

My mdf file size 17 MB , LDF SIZE 147 MB

Is there any way to retrive the data from LDF file.

If you actually did TRUNCATE TABLE, then I believe your prospects are
very bleak.

If you used the DELETE command, a log-reader tool can help you. Examples
of such are Lumigent Log Exploer and LOG PI. http://www.lumigent.com,
http://www.logpi.com/.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Problem with database filegroup restructuring in SQL Server?
    ... print 'Move db contents to MDF file' ... database '' because the 'Data Filegroup 1' filegroup is full. ... Please check Books Online, for the exact syntax. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Lost ldf file
    ... How do so many people "lose" an LDF file??? ... "Lauren Quantrell" wrote in message ... I have tried to attach this to SQL Server 2000 and MSDE with no ... > but it seems I cannot use that ldf file with the more recent mdf file. ...
    (microsoft.public.sqlserver.server)
  • Re: Lost Log File !
    ... Create a new database with same MDF and LDF name ... stop sql server and delete the new MDF file and copy the old MDF file ... Start SQL Server and see the status. ... > Create a new database with same MDF and LDF name ...
    (microsoft.public.sqlserver.clients)
  • Re: Saving .mdf database
    ... Which will not save your .mdf and .ldf files, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: OLEDB connection string for .MDF (?)
    ... My question was about the possibility of using the standard SQL Server ... or SQL OleDb provider does not support .mdf files: ... The .mdf file is assumed to ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)