It seems that there is some incompatibility with 2008 and TranScend I've been running on Sql Server 2005. Would love the updated scripts to make it compatible. Intrix doesn't seem to be of much help.
Unknown said: It seems that there is some incompatibility with 2008 and TranScend I've been running on Sql Server 2005. Would love the updated scripts to make it compatible. Intrix doesn't seem to be of much help.
We are setting up a test server here on Windows Server 08R2 and SQL 08R2, so I've been in communication w Intrix on compatibility, too. They indicated to me that other than the TPAU and TPAUARCHIVE databases being kept in Compatibility Mode 80 or 90, Transcend should have no other requirements for SS08R2.
I'm just getting Transcend installed now (btw, this installer and updater must be some of the most, ah, awkwardly designed I've ever seen!), so we'll see if I run into any issues.
Were the issues you've seen outlined in the compatibility tool? I ran it and that is where I was made aware of the issues.
Intrix mentioned nothing about any compatability mode. They only said...
The Dump statement was dropped in SQL 2008. TranScend uses this statement in the stored procedure P_TPAU_MANAGE_TRANSACTION_LOG. This procedure is used for truncating the transaction logs and backing up the database. You will have to comment out the line in P_TPAU_4XDAILY_MAINT (Databases>TPAU>Programmability>Stored Procedures>right click>Modify) which calls the procedure.
Your options are then to set the recovery mode to SIMPLE (No Backup) or FULL.
You will then have to create your own maintenance schedule and backup the logs and database on a timely basis.
Will the Compatibility Mode 80 address this?
Unknown said: Were the issues you've seen outlined in the compatibility tool? [...] Will the Compatibility Mode 80 address this?
Were the issues you've seen outlined in the compatibility tool? [...]
We haven't actually observed any issues. The mention of compatibility mode 80 or 90 came in an e-mail from Intrix support in response to our query about SS08R2 requirements for Transcend. We are just getting this set up in a non-Live environment now.