Long story but our long term consultants (former employees) wrote a custom script years back (2006 or so) to interface with Tivoli Storage Manager and it appears to be checking for a SQL Server DB option named truncate log on checkpoint
. Their claim is that it prevents the scripts from functioning and performing backups on the instance which is SQL 2012.
I feel that's complete BS since I cannot find any such option via sp_configure
and backups are working everywhere but one instance. However I would like to remove a land mine, if that's what it is, and remove other obsolete elements. I do have them checking with the vendor but I don't have a high degree of confidence in anything that they say.
The research I did returned little more than it perhaps being an option for SQL 2000 or a Sybase option. Another claim was that it's called/used implicitly on later versions (2008 and up) when the recovery model is SIMPLE
and there's no explicit option to turn it on or off.
Since the TRUNCATE LOG
command is obsolete due to how transaction logs work these days, I think it's not an option that can even be queried at this point.
As I don't have any SQL Server 2000 instances about, I was hoping someone might recall this or could check it on one they have laying around. I've told them that it's nothing I can recommend. I was also hoping that someone can confirm this is obsolete.