Stack Overflow
Stack Overflow

Questions tagged [ldf]

A transaction log file (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. Physically, a log is a file of updates done to the database, stored in stable storage. (from wikipedia)

48 questions
80
votes
3 answers

What are NDF Files?

SQL Server uses .mdf for data files and .ldf for log files, but what are .ndf files? What are the benefits of these files?
Nasser Hadjloo
  • 12,312
  • 15
  • 69
  • 100
18
votes
7 answers

How to rename the Physical Database Files

I have used tsql to detach a database like this: EXEC sp_detach_db @dbname = 'my_db' I then made use of PHP to rename the physical files. I was able to rename the mdf file but not the ldf file! I even tried a dos command REN but that didn't work…
Abs
  • 56,052
  • 101
  • 275
  • 409
6
votes
1 answer

how can i see data in mdf file

i have asp.net application. it has App_Data folder. this folder contain mdf and ldf file. how can i see data within these file. i want to see table structure.
Novice Developer
  • 4,489
  • 11
  • 39
  • 42
5
votes
1 answer

how to convert Mdf/ldf database files to .bak file (db restore) using T-SQL or .net code

I have sql server database files (Mdf/Ldf) and i want to convert them to backup file using T-SQL commands or .net Code (C# or Vb.net). any suggestions. thans
Amr Elnashar
  • 1,739
  • 12
  • 33
  • 53
4
votes
3 answers

openGL into png

I'm trying to convert an openGL [edit: "card that I drew"(?):) thx unwind]containing a lot of textures (nothing moving) into one PNG file that I can use in another part of the framework I'm working with. Is there a C++ library that does…
majdal
  • 477
  • 1
  • 5
  • 18
4
votes
4 answers

openGL textures that are not 2^x in dimention

I'm trying to display a picture in an openGL environment. The picture's origninal dimensions are 3648x2432, and I want to display it with a 256x384 image. The problem is, 384 is not a power of 2, and when I try to display it, it looks stretched. How…
majdal
  • 477
  • 1
  • 5
  • 18
3
votes
3 answers

How to open the SQL Server Transaction Log File(LDF)?

I mean the way to open the LDF file and read/analyze it. Now, I have ability to extract the backup LDF file, but it seems that the LDF file is SHARE_DENY_READ when the database is working. But the other 3rd-party software like Lumigent Log…
BlackThought
  • 31
  • 1
  • 2
  • 3
3
votes
1 answer

How could I reduce the size of log file?

I have done a delete operation on a table with many records, so my log file grew from 15 GB to 58 GB. At some point I canceled the execution of delete query because my hdd was running out of space. I have seen here how to delete this big amount of…
Ionut
  • 724
  • 2
  • 9
  • 25
3
votes
4 answers

How to query from log files (.ldf) of Sql Server 2005 Express edition?

I want to do this, because I would like to know how many times a particular row has been changed. Is this possible? Thanks
Jey Geethan
  • 2,235
  • 5
  • 33
  • 60
2
votes
1 answer

Determine MDF and LDF file match

Is there a way to determine what MDF goes with what LDF file for SQL Server? We had a server crash and pull these files off and were only named with a random integer for the file name. So now we need to guess which MDF and LDF go together to get…
Mike Flynn
  • 22,342
  • 54
  • 182
  • 341
2
votes
1 answer

Attach a database using MDF file that is Read-only and without LDF file in SQL Server

I want to attach a DB to SQL Server. I have the mdf files for it but those are in read-only state. Also the LDF file is not present. I use the following command to attach the DB. Create database TrackData on (Filename = N'F:\Data\Bill_Data.mdf')…
Madhur Maurya
  • 1,016
  • 4
  • 19
  • 42
2
votes
1 answer

SQL Server - View a specific log entry in transaction log file (ldf)

This may have been asked before but I made a simple update to one column (varchar(max)) in a table and wanted to know if there is a simple way to look at the transaction log file (ldf) to see that specific update? Can you possibly provide specific…
Benj Sanders
  • 481
  • 5
  • 15
2
votes
1 answer

How can I find information about updating or inserting a sql table row in sql server 2008?

I am looking for information about my table history, I have to know the time that specific row was inserted is there someway to know it? thanks.
mich
  • 127
  • 1
  • 1
  • 12
1
vote
1 answer

ldf is not supported

I install asammdf package to read dat file in python. After installing asammdf using pip install asammdf, the installation is successful. However, when I import asammdf, I got ldf is not supported. May I know how to solve this issue and after…
Susan
  • 431
  • 1
  • 4
  • 16
1
vote
0 answers

SQL Server log file (.ldf) being spammed with LOP_FORMAT_PAGE entries

To start I am new to digging into .ldf entries, I don't even know how to track any of these logs back to the objects creating them, if someone could explain that in their answer it would be appreciated. Anyways, I have a SQL Server setup with a few…
Zeckal
  • 145
  • 1
  • 9
1
2 3 4