Force Shrink Log

[Lauryn]

Id like to know how I force the transaction log to shrink in v2000?

I have sp_force_shrink_log but this only works in v7.

... Also, how do I set the log to truncate on checkpoint?


Many thanks,
Lauryn

[Chakri]

You can use DBCC shrinkfile (filename, size) to shrink the log file.
Filename is the logical file name of the transaction log and size is that you wish to have after shrinking.

In SQL 2000 you have to set the recovery model of the database to 'simple' for truncating the log on checkpoint. You can find this option by right clicking on the database and clicking properties.



------------
Lauryn at 1/15/2002 10:05:34 AM

Id like to know how I force the transaction log to shrink in v2000?

I have sp_force_shrink_log but this only works in v7.

... Also, how do I set the log to truncate on checkpoint?


Many thanks,
Lauryn