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
0
votes
1 answer

Selecting LDF file using sys.master_files

This might be simple but can not find example of selecting LDF file form sys.master_files. I have got the MDF file using cmd.CommandText = ("select physical_name from sys.master_files where database_id = DB_ID('" + "mydatabasename" + "')");
Jed I
  • 998
  • 3
  • 19
  • 37
-1
votes
1 answer

How to rollback database only with MDF and LDF files but without backup file?

Is it possible to rollback only with MDF and LDF files but without backup file? I worked days but suddenly it's gone. It's important to me.
Kay Lee
  • 922
  • 1
  • 12
  • 40
-2
votes
1 answer

CANoe use 2 LDF

Is it possible to use 2 LDF in the same CANoe configuration ? Right now when I try to add the second LDF I get this error message:
1 2 3
4