dbcc loginfo

dbcc loginfo

Post by Jaime McGeath » Wed, 29 Mar 2000 04:00:00



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

 
 
 

dbcc loginfo

Post by Andrew J. Kell » Wed, 29 Mar 2000 04:00:00


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


 
 
 

dbcc loginfo

Post by Neil Pik » Wed, 29 Mar 2000 04:00:00


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
 
 
 

dbcc loginfo

Post by Kalen Delane » Wed, 29 Mar 2000 04:00:00


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

 
 
 

1. Shrink Log file - dbcc loginfo all Status 2

G'Day Rears.

I'm having trouble shrinking my log file.
data 38MB
log 37GB

Where did I go wrong?!

Can somebody please give me a step by step guide to shrinking a log
file or a URL where I can find a guide?

the below is 19 lines from the results of dbcc loginfo command, there
is 580 more lines and all have Status=2 apart from 3

FileSize        StartOffset     FSeqNo  Status  Parity
10092544        427556864       413     2       64
10944512        437649408       412     2       64
10944512        448593920       411     2       64
10944512        459538432       410     2       64
10944512        470482944       409     2       64
11993088        481427456       408     2       64
11993088        493420544       407     2       64
11993088        505413632       406     2       64
12189696        517406720       405     2       64
13238272        529596416       404     2       64
13238272        542834688       403     2       64
13238272        556072960       402     2       64
13238272        569311232       401     2       64
14548992        582549504       400     2       64
14548992        597098496       394     2       64
15269888        611647488       601     2       64
15269888        626917376       600     2       64
15269888        642187264       599     2       64
15400960        657457152       598     2       64

2. MSDE and Enterprise Manager

3. DBCC loginfo

4. NT Auth

5. dbcc loginfo

6. Win98 --> MSDE 2000 Problem

7. need help with "dbcc loginfo"

8. Custom on WebDB

9. DBCC LOGINFO COMMAND

10. DBCC loginfo documentation?

11. DBCC LOGINFO

12. dbcc loginfo, etc.

13. What is DBCC Loginfo() ?