Top "Ldf" questions

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.

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 …

sql-server tsql mdf ldf
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 …

sql-server ldf
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 …

sql-server database-restore mdf ldf