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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide