Author Topic: Anyone have an archive script for CCM/SQL Express?  (Read 1813 times)

Offline matthew

  • Full Member
  • ***
  • Posts: 123
  • Country: au
  • Karma: +2/-0
    • View Profile
Anyone have an archive script for CCM/SQL Express?
« 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?


Offline sarond

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1404
  • Country: au
  • Karma: +73/-0
    • View Profile
Re: Anyone have an archive script for CCM/SQL Express?
« Reply #1 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

Offline matthew

  • Full Member
  • ***
  • Posts: 123
  • Country: au
  • Karma: +2/-0
    • View Profile
Re: Anyone have an archive script for CCM/SQL Express?
« Reply #2 on: December 23, 2014, 05:02:39 PM »
You, Sir, are a gentleman.  :)


 

Sitemap 1 2 3 4 5 6 7 8 9 10