DBCC LOGINFO('dbname')
- To view the VLF (Virtual Log File) layout.
- SQL Server truncates the log files in unit of VLF.- On result "status=2" denotes the VLF is in use.
Subscribe to:
Post Comments (Atom)
Adding fuel to my passion on SQL Server
No comments:
Post a Comment