Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TM - CDR 1

Status
Not open for further replies.
Pir8Radio

Pir8Radio

Technical User
Jul 31, 2004
291
US
Hi all... We upgraded from OTM to the latest TM a few months ago... Just curious, what is the largest TM CDR database size? I used to keep two years worth before archiving... 01/01/2010 to 10/28/2010 i have 2,284,645 calls in the database and its not letting me cost any more i get error "database has reached maximum size"!? not even a whole year now? Is there a setting for database size, i didnt think so... if not what is the maximum size? :) (yea i know... 2,284,645 records)

Thanks!
 
Sort by date Sort by votes
I beleive the max size CDR MDBfile for each site before it starts to corrupt is around a Gig

Cheers!!
 
Upvote 0 Downvote
eek... looks like your right... our database is at 1 gig exactly.... Alright thanks..
 
Upvote 0 Downvote
WHY would you keep 2 years of data in play on that server? Do you have 20 tenants? Is this a law firm? Do you have problems with calls? Do you charge for calls? Do you pull records everyday? Just wondering... Large databases tend to slow down any server.

DocVic
Dedicated to Nortel Products till the end.
Need help?
 
Upvote 0 Downvote
Well the database runs quick actually... The new TM vs OTM pulls reports in a few seconds, OTM with a large DB took a few mins... Its easier to trend things out the more data you have... I know i can pull the old stuff in.. but this has always worked.. Well in the past...

We are a newspaper, we do bill out calls we take for other orginizations, we auto run reports nightly. We do trunk side call recording that crosses with the CDR data in OTM. But all of that said, i dont NEED 2 years in there, it just becomes more work for me.. After I cleaned things up, looks like 6 months of calls is a little under 2 million calls/records. Which is about right, +-320,000 calls/month.
 
Upvote 0 Downvote
Good idea to compact each MDBfile size once 'Archived'
which you can select from 'Utilities' option from that site
to allow you to select

Cheers!!
 
Upvote 0 Downvote
riddle me this batman.... So i archived my year and a half down to 6 months and the MDB size is exactly the same? yet when i go to VIEW DATABASE there are indeed only 6 months of records? the gig MDB file is the active database, so im not looking at an old one or anything.
 
Upvote 0 Downvote
Yep hence my 'compact' suggestion...Did you do this

Cheers!!
 
Upvote 0 Downvote
I've found a re-start on the TM server is another way

Cheers!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MoJHK
  • Locked
  • Question
Nortel Basic ACD in CDR
Replies
0
Views
240
MoJHK
MoJHK
SherWat
  • Locked
  • Question
NTRB21 TMDI Card Questions
Replies
3
Views
412
bignose21
bignose21
telklass
  • Locked
  • Question
Print CDR info from calls on CS1000
Replies
9
Views
650
telklass
telklass
lapakhora
  • Locked
  • Question
CDR-Access code issue
Replies
2
Views
205
lapakhora
lapakhora
sreejeshdxb
  • Locked
  • Question
Conference call CDR end record
Replies
2
Views
159
StanleySteamer
StanleySteamer

Part and Inventory Search

Sponsor

Back
Top