if you are familiar with Microsoft SQL server, you found that when you create one database two files are created the first one called data file (.mdf) and another file called log file (.ldf) the interesting point there that the log file is group of small virtual log files. the writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well.

you can use the following command to check how many VLFs in the log files

DBCC LOGINFO

Note that the value of the status column, 2 mean is active one and 0 mean is inactive

if you are familiar with Microsoft SQL server, you found that when you create one database two files are created the first one called data file (.mdf) and another file called log file (.ldf) the interesting point there that the log file is group of small virtual log files. the writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well.

you can use the following command to check how many VLFs in the log files

DBCC LOGINFO

Note that the value of the status column, 2 mean is active one and 0 mean is inactive

if you are familiar with Microsoft SQL server, you found that when you create one database two files are created the first one called data file (.mdf) and another file called log file (.ldf) the interesting point there that the log file is group of small virtual log files. the writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well.

you can use the following command to check how many VLFs in the log files

DBCC LOGINFO

Note that the value of the status column, 2 mean is active one and 0 mean is inactive

if you are familiar with Microsoft SQL server, you found that when you create one database two files are created the first one called data file (.mdf) and another file called log file (.ldf) the interesting point there that the log file is group of small virtual log files. the writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well.

you can use the following command to check how many VLFs in the log files

DBCC LOGINFO

Note that the value of the status column, 2 mean is active one and 0 mean is inactive

if you are familiar with Microsoft SQL server, you found that when you create one database two files are created the first one called data file (.mdf) and another file called log file (.ldf) the interesting point there that the log file is group of small virtual log files. the writing of the VLF is sequential and resulting in the writing of the LDF file is sequential as well.

you can use the following command to check how many VLFs in the log files

DBCC LOGINFO

Note that the value of the status column, 2 mean is active one and 0 mean is inactive