05-27-2009 09:43 AM - edited 03-15-2019 06:13 PM
Does anybody know if I can delete file CDR_LOG.LDF to free space in order to run DMA? How does this affact the DMA process? Thanks for any help!
Steve
Solved! Go to Solution.
05-27-2009 10:09 AM
Don't DELETE FILES. If CAR is installed or was ever installed, you can purge the CDR records and the CAR stuff that way.
You can also write an SQL script to delete records, probably compact the databases, etc.
You can also have SQL backup the CDR and CAR files (use Enterprise manager) to put them on another server in case you need them.
PURGING the files as described above will make your DMA file MUCH smaller and quicker to migrate.
Also make sure detailed tracing is not turned on. You can also adjust the trace files settings to less files and less size per file. You MIGHT be able to delete some trace files (if done properly,) but I'm not going to sanction that.
05-27-2009 10:09 AM
Don't DELETE FILES. If CAR is installed or was ever installed, you can purge the CDR records and the CAR stuff that way.
You can also write an SQL script to delete records, probably compact the databases, etc.
You can also have SQL backup the CDR and CAR files (use Enterprise manager) to put them on another server in case you need them.
PURGING the files as described above will make your DMA file MUCH smaller and quicker to migrate.
Also make sure detailed tracing is not turned on. You can also adjust the trace files settings to less files and less size per file. You MIGHT be able to delete some trace files (if done properly,) but I'm not going to sanction that.
11-10-2009 12:17 PM
Hi Michael,
Thanks a lot for your reply.
I was also looking for an answer for the same Qn.
+5 for you.
11-10-2009 08:24 PM
NO problem. Glad an older, "archived" message worked for you many months later.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: