What is Vlf(Virtual Log File)? Vlf (Virtual Log File) is a virtual file, as the name implies. The Transaction Log file with the ldf extension in …
Read More »Tag Archives: vlf
How To Add Second Log File To The Database
Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk …
Read More »How To Shrink SQL Server Transaction Log
Before shrinking the SQL Server log file, I recommend you read articles “What is SQL Server Transaction Log” and “What is Database Recovery Model” that …
Read More »What is SQL Server Transaction Log
SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions …
Read More »