Very Computer

Where can I find any documentation on this?  I know that a status of 2 means
active, put how do you tell which virtual file is the last one and what do
the other columns mean?

Thank you,
Jaime

Jamie,

    This is an undocumented SP and thus you aren't going to find it in BOL
or such. But the skinny is like this. Status of 2 means that the VLF(Virtual
Log File) has active transactions in it. They are listed in physical order
so if you have a VLF at the bottom with a status of 2 you can not shrink the
log file until you wrap the active transactions around to another VLF. You
really don't have to worry about the columns other than Status since you
can't really effect them anyway other than removing some of the rows(VLF's)
if you issue a DBCC SHRINKFILE.

Andy

Quote:> Where can I find any documentation on this?  I know that a status of 2
means
> active, put how do you tell which virtual file is the last one and what do
> the other columns mean?

> Thank you,
> Jaime

Jaime - check "inside sql server 7.0"

Quote:> Where can I find any documentation on this?  I know that a status of 2 means
> active, put how do you tell which virtual file is the last one and what do
> the other columns mean?

> Thank you,
> Jaime

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq

Actually, this command didn't make it into the book, because I didn't find
out about it until after the book went to Press. But I did talk about dbcc
loginfo in one or two of my SQL Magazine columns.

The status of 2 does not just mean that the VLF contains active
transactions. It means that the VLF is 'needed' by SQL Server. It may be
needed because it has active transactions, but it may be needed because it
has not been backed up yet. Backing up the log will frequently change a
bunch of the 2's to 0's.

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com

Quote:> Jaime - check "inside sql server 7.0"

> > Where can I find any documentation on this?  I know that a status of 2
means
> > active, put how do you tell which virtual file is the last one and what
do
> > the other columns mean?

> > Thank you,
> > Jaime

>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  (Please reply only to newsgroups)
>  SQL FAQ (428 entries) see
>  forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
(sqlfaq.zip - L7
> - SQL Public)
>  or www.ntfaq.com/sql.html
>  or www.sql-server.co.uk
>  or www.mssqlserver.com/faq