• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

LDF File

 
Robert Aryan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can I read LDF file . I dont have any SQL server. Only have LDF file
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
According to a quick web search, the LDF file contains a transaction log. It is probably proprietary format and I doubt any free utility to process it exists.

What do you want to do with the file?
 
Robert Aryan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to see some transactions.There are some utilities(ApexSQL etc) but in that we have to connect to SQL Server.
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The file has been created by an MS SQL Server installation. Why can't you use that same installation to read it?
 
Robert Aryan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We don't have access to production database(SQL Server) they gave us the ldf file only.
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you try the following:
- Install SQL Server Express.
- Create a new database with the same name, so a new LDF file with the same name will be created.
- Shutdown SQL Server Express*.
- Replace the new LDF file with the existing one.
- Restart SQL Server Express.

This may work, although it wouldn't surprise me if it didn't because the new database doesn't have the same structure.

* It's also possible to detach the files from the database and reattach them but that requires to call a duo of stored procedures. This way is easier.
 
Robert Aryan
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks its work for me.
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You're welcome
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic