Interview Questions
1. What are Virtual Log files? How these are created?
SQL Server Database Engine divides each physical log file internally into a number of virtual log files. Virtual log files have no
fixed size, and there is no fixed number of virtual log files for a physical log file. The Database Engine chooses the size of the
virtual log files dynamically while it is creating or extending log files. The Database Engine tries to maintain a small number of
virtual files. The size of the virtual files after a log file has been extended is the sum of the size of the existing log and the size
of the new file increment. The size or number of virtual log files cannot be configured or set by administrators.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment