SQL Server DBCC LOGINFO – Observing Virtual Log

Hi Friends, We can have more than one log file for a database. However, in many cases a single log file suffices. Logically, a log file is divided into a number of virtual log files. The virtual log file concept allows SQL Server to manage various operation on the log file, including checkpoints, various phases [...]