04-10-2007 05:07 AM - edited 03-14-2019 08:54 PM
Hi Guys,
Our Customer has a HD of 16Ghz in the CCM that is almost full, to liberate space I requested that he disable the Traces, however, it would like to leave the CDR and MLA enable. I ask, exists some configuration in the CCM exists that to make possible that these log?s are directed for another server/machine, in way that they continue to be safe or this has of being made of manual form?
Thank You
04-10-2007 05:17 AM
please use the following procedure to store CDR records on a separate server:
------------------
In the callmanager server go to:
start > programs > Microsoft SQL server > Import and Export data.
The "Data Transformation Services Import/Export Wizard" initial window appears. Click next. The Data Source (from where you will be copying data) window is displayed.
Data Source = Microsoft OLE DB Provider for SQL Server.
Server = (local)
If you are using any callmanager version 4.x, use Windows authentication.
If you are using any callmanager version 3.x, use SQL server authentication (you will be prompted to enter the username and password for the SQL administrator).
Database = CDR
Click Next. The Destination (to where do you want to copy data) window is displayed.
Destination = The default is "Microsoft OLE DB Provider for SQL Server"; however, you can choose here other data formats.
Server = From the drop down list, select the name of the server to which you want to export the CDR database.
Select the appropiate authentication method (Windows authentication or SQL server authentication).
Database = select "new" from the drop down list and then you are prompted to enter a name and a size for the new database. Click OK to accept those settings, then click on next.
The "Specify Table Copy or Query" window is displayed.
Select the option "Copy table(s) and view(s) from the source database".
Click next.
The "Select Source Tables and Views" window is displayed. Select all the objects by checking the checkboxes. Click Next.
The "Save, schedule, and replicate package" window is displayed.
As you are performing this procedure after hours, just check the "Run immediately" checkbox and then click on Next.
Verify the information that you provided in the "Summary" window, then click on "Finish". You will be informed if the copy procedure was successful. Click on OK, then click on Done.
Now go to the new server and verify the information is there.
HTH
//Jorge
04-10-2007 06:35 AM
Hi Jorge,
Thank You for your assistance. The procedure is the same for MLA?
Wilson
04-10-2007 05:18 AM
Another option is to shrink the CDR and ART
The following procedure is used to shrink these files:
##################################################################
Open a command prompt and type:
C:\>osql -E
1> use cdr
2> go
1> backup log cdr with no_log
2> go
1> dbcc shrinkdatabase (cdr)
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
13 1 368 96 360 360
13 2 96 63 96 56
(2 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
1> create table Test (test int DEFAULT NULL NULL)
2> go
1> insert into Test (test) VALUES (1)
2> go
(1 row affected)
1> declare @t integer
2> set @t = 0
3> use cdr
4> while (@t <= 100000)
5> BEGIN
6> update Test set test=1 where test=1
7> select @t = @t + 1
8> if ((@t % 500) = 0)
9> BEGIN
10> select @t
11> END
12> END
13> go
// you will see a lot of "(1 row affected)"
(1 row affected)
(1 row affected)
(1 row affected)
(1 row affected)
-----------
100000
(1 row affected)
(1 row affected)
1> drop table test
2> go
1> checkpoint
2> go
1> dbcc shrinkdatabase (cdr)
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
13 1 368 96 360 360
13 2 96 63 96 56
(1 row affected) DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
##################################################################
use the same commands for ART, just replace cdr for art.
04-13-2007 04:12 AM
Hi Jorge !
Can't I just replace the default UNC PATH information (on the Enterprise Parameters) inserting the external server address/directory and have my CDRs directed to them ?
Thanks !
Rodrigo
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