ldf文件怎么看,ldf文件用什么打开?



ldf文件怎么看,ldf文件怎么打开?用什么打开?

.ldf

文件类型:SQL Server Transaction Log File

扩展名为.ldf的文件是一个数据文件。

文件说明:

Log file created by SQL Server, a relational database management system (RDBMS) developed by Microsoft; contains a log of recent actions executed by the database; used to track events so that the database can recover from hardware failures or other unexpected shutdowns.

LDF files are transaction logs; these logs contain a history of activity for both fully committed and partially committed transactions to the database (the .MDF file); after an unexpected shutdown, SQL Server can use the transaction log to restore the database to the exact state before the failure.

Transaction logs can be truncated once the database creates a checkpoint, which is a stable state of the database and the log file; RDBMS systems can then safely delete all log data up to the point of the checkpoint, reducing the log file size.

NOTE:

LDF files can become very large in size; this is due to the fact that no checkpoint has recently been created; however, it may also be due to open transactions that have not yet been fully committed, or other locks on database records..ldf

打开.ldf文件

Mac OS

 

Windows

Microsoft SQL Server 

Linux

其它内容

来源:.ldf文件


上一篇:lgh文件怎么看,lgh文件用什么打开?

下一篇:lbt文件怎么看,lbt文件用什么打开?


ldf文件 ldf
Copyright © 2002-2019 k262电脑网 www.k262.cn 皖ICP备2020016292号
温馨提示:部分文章图片数据来源与网络,仅供参考!版权归原作者所有,如有侵权请联系删除!QQ:251442993 热门搜索 网站地图