April 8, 2017 at 7:06 am
What is .ldf file?
what .ldf file contains?
how to see .ldf data files?
what to do if .ldf files full?
how to take back up and recovery of .ldf /?
April 8, 2017 at 8:30 am
ldf is Log data file, i.e. the Transaction Log of a database in SQL Server.
It logs the transactions and data modifications in the database.
Right click on the database go to Properties and then chose Files and you'll see there the log file (File type = LOG)
For details, read this stairway - http://www.sqlservercentral.com/stairway/73776/
Igor Micev,My blog: www.igormicev.com
May 3, 2017 at 11:10 pm
This was removed by the editor as SPAM
June 21, 2017 at 9:06 am
Hi
You may also refer to this useful article entitled "A beginner’s guide to SQL Server transaction logs"
https://www.sqlshack.com/beginners-guide-sql-server-transaction-logs/
Best Regards,
June 21, 2017 at 1:19 pm
Ricky Valencia - Wednesday, June 21, 2017 9:06 AMYou may also refer to this useful article entitled "A beginner’s guide to SQL Server transaction logs"
https://www.sqlshack.com/beginners-guide-sql-server-transaction-logs/
There's a bunch of errors in there, read, but verify.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2018 at 3:13 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply