Does somebody know where I can truncate transaction protocolls on SQL Server 2000?


Thanks
Spartacus

Hi Spartacus,

I am not sure what you mean by shrinking transaction protocols.
I am not an SQL server expert (well, actually I am but it's been a while. lol), and I am assuming that you mean to truncate the transaction LOG file.

In that case,
The size of the log files are physically reduced when:

A DBCC SHRINKDATABASE statement is executed.

A DBCC SHRINKFILE statement referencing a log file is executed.

An autoshrink operation occurs.

Of course I may have missed the point by a mile here, but considering the fact that there hasn't been a reply in a week, I must not be the only one who has frowned on this question ;)

Maybe it's similar to SQL 7.

In SQL Enterprise Manager open the database (for baan it's baandb). Click database properties. The third folder Options has a checkbox Truncate log on Checkpoint - check that.

Please note that in Production database you normally leave this to unchecked. Reason is the transaction logs need to be saved regularly through database maintenance and truncating it will not save the logs.

I should be installing my SQL 2000 in the next couple of weeks.

Hi,

thanks to all. Our database people found it out meanwhile. Btw.: we also have has not enaugh space on the partition.


Greetings
Spartacus