transaction log question

[Rachel]

How can you tell that the active log has moves to the top?

thanks

[Craig]

There is no active log concept in sql server, that is an Oracle or Informix thing. Sql server has only one log..........


------------
Rachel at 7/17/00 12:51:12 PM

How can you tell that the active log has moves to the top?

thanks

[Rachel]

Craig,
I was reacting to this email and was curious at #4

Subject:
From:
Date: MSSQL 7 Log File Resizing (reply)
(chander.oberoi@cognos.com)
7/14/00 10:38:59 AM

1- backup log (db name) with truncate_only
2- dbcc shrinkfile('log file name', size u want to reduce to, notruncate)
3- dbcc shrinkfile('log file name', size u want to reduce to,truncateonly)
4- create dummy transaction against a test table until the active log moves to the top.
5- backup log (db name) with truncate_only








------------
Rachel at 7/17/00 12:51:12 PM

How can you tell that the active log has moves to the top?

thanks

[Duncan Maddox]

I presume this is referring to the VLFs ( Virtual Log Files ) ... the way Transaction Logs are internally partitioned.

DBCC LOGINFO is an undocumented command which gives some relevant information, the currently active VLF has status=2.

Duncan

------------
Rachel at 7/17/00 3:33:41 PM

Craig,
I was reacting to this email and was curious at #4

Subject:
From:
Date: MSSQL 7 Log File Resizing (reply)
(chander.oberoi@cognos.com)
7/14/00 10:38:59 AM

1- backup log (db name) with truncate_only
2- dbcc shrinkfile('log file name', size u want to reduce to, notruncate)
3- dbcc shrinkfile('log file name', size u want to reduce to,truncateonly)
4- create dummy transaction against a test table until the active log moves to the top.
5- backup log (db name) with truncate_only








------------
Rachel at 7/17/00 12:51:12 PM

How can you tell that the active log has moves to the top?

thanks

[Craig]

Concur. Sql server uses a single log with logical partioning as Duncan described.


------------
Duncan Maddox at 7/18/00 6:54:27 AM


I presume this is referring to the VLFs ( Virtual Log Files ) ... the way Transaction Logs are internally partitioned.

DBCC LOGINFO is an undocumented command which gives some relevant information, the currently active VLF has status=2.

Duncan

------------
Rachel at 7/17/00 3:33:41 PM

Craig,
I was reacting to this email and was curious at #4

Subject:
From:
Date: MSSQL 7 Log File Resizing (reply)
(chander.oberoi@cognos.com)
7/14/00 10:38:59 AM

1- backup log (db name) with truncate_only
2- dbcc shrinkfile('log file name', size u want to reduce to, notruncate)
3- dbcc shrinkfile('log file name', size u want to reduce to,truncateonly)
4- create dummy transaction against a test table until the active log moves to the top.
5- backup log (db name) with truncate_only








------------
Rachel at 7/17/00 12:51:12 PM

How can you tell that the active log has moves to the top?

thanks