当前位置：网站首页>In the SQL SERVER database, if the data of the table is added, deleted, or modified, will the index of the table be recorded in the ldf log?

In the SQL SERVER database, if the data of the table is added, deleted, or modified, will the index of the table be recorded in the ldf log?

2022-08-10 07:42:00 【Wang Yunliang】

1. The SQL SERVER database is in full mode. There is an existing business table and several indexes are added. Under the same business scale, will the log ldf file grow more than before adding indexes?

2. When a table is added, deleted, or modified, the ldf log will be written. The index of the table will also be updated synchronously when the data in the table changes. Whether this process will write the ldf log.


Other Answer 1:
  1. Yes.
  2. Yes.
    ldf log will record all changes in the database, data and index page changes will be recorded.
    Database crash recovery, mirroring, replication and other functions all rely on ldf files.
原网站

版权声明
本文为[Wang Yunliang]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/222/202208031628466085.html

边栏推荐

猜你喜欢

随机推荐