Mitel Forums - The Unofficial Source

Mitel Forums => Mitel Software Applications => Topic started by: matthew on December 22, 2014, 06:04:29 PM

Title: Anyone have an archive script for CCM/SQL Express?
Post by: matthew on December 22, 2014, 06:04:29 PM

Customer has SQL Express 2008. Databases are getting close to the 10Gb limit. I'd like to prune out old records that they don't care about anymore. Given enough time I'm generally able to find my way around SQL stuff, but don't want to develop an archiving script on the customer's live database. I'm sure somebody has dealt with this before..  :)

Alternatively, is there some function that I have overlooked in CCM that does this?

Title: Re: Anyone have an archive script for CCM/SQL Express?
Post by: sarond on December 23, 2014, 04:32:54 AM

Yes Prairiefyre (Mitel) have a tool for this. It purges old data.

http://micc.mitel.com/kb/KnowledgebaseArticle50933.aspx

Title: Re: Anyone have an archive script for CCM/SQL Express?
Post by: matthew on December 23, 2014, 05:02:39 PM

You, Sir, are a gentleman.  :)