Does the .LDF file contains table changes, added triggers and views, created stored procedures?
.LDF文件是否包含表更改,添加的触发器和视图,创建的存储过程?
As I have read here, it states that the .LDF file contains add and delete transactions, does that include everything that you did in the server?
正如我在这里读到的,它声明.LDF文件包含添加和删除事务,是否包括您在服务器中执行的所有操作?
I would also like to add, what is the use of the .MDF file?
我还想补充一点,.MDF文件的用途是什么?
Please do take note I have my server on Standard edition and in FULL recovery
请注意我的标准版和完全恢复服务器
1 个解决方案
#1
0
LDF Contains a list of the last actions (transactions) performed in the database ( MDF file ). Used to track events so that the database can be restored in the event of equipment failure or other unexpected problems. The .LDF files are transaction logs. They contain an activity history for fully and partially completed transactions in the database. After an unexpected outage, SQL Server can use the transaction log to restore the database. MDF file is primary database file of a SQL Server database which contains all the database objects like Table, Triggers, Views, SPs etc.
LDF包含数据库中执行的最后一个操作(事务)的列表(MDF文件)。用于跟踪事件,以便在设备发生故障或其他意外问题时可以恢复数据库。 .LDF文件是事务日志。它们包含数据库中完全和部分完成的事务的活动历史记录。意外中断后,SQL Server可以使用事务日志来还原数据库。 MDF文件是SQL Server数据库的主数据库文件,其中包含所有数据库对象,如表,触发器,视图,SP等。
Take a look on here to know how to read LDF file in SQL Server using fn_dblog() function and SysTools SQL Log Analyzer.
看一下这里,了解如何使用fn_dblog()函数和SysTools SQL Log Analyzer在SQL Server中读取LDF文件。
#1
0
LDF Contains a list of the last actions (transactions) performed in the database ( MDF file ). Used to track events so that the database can be restored in the event of equipment failure or other unexpected problems. The .LDF files are transaction logs. They contain an activity history for fully and partially completed transactions in the database. After an unexpected outage, SQL Server can use the transaction log to restore the database. MDF file is primary database file of a SQL Server database which contains all the database objects like Table, Triggers, Views, SPs etc.
LDF包含数据库中执行的最后一个操作(事务)的列表(MDF文件)。用于跟踪事件,以便在设备发生故障或其他意外问题时可以恢复数据库。 .LDF文件是事务日志。它们包含数据库中完全和部分完成的事务的活动历史记录。意外中断后,SQL Server可以使用事务日志来还原数据库。 MDF文件是SQL Server数据库的主数据库文件,其中包含所有数据库对象,如表,触发器,视图,SP等。
Take a look on here to know how to read LDF file in SQL Server using fn_dblog() function and SysTools SQL Log Analyzer.
看一下这里,了解如何使用fn_dblog()函数和SysTools SQL Log Analyzer在SQL Server中读取LDF文件。