cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
311
Views
10
Helpful
4
Replies

Hard Disk Full

wilsonsant
Level 6
Level 6

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

4 Replies 4

jbarcena
Level 9
Level 9

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

Hi Jorge,

Thank You for your assistance. The procedure is the same for MLA?

Wilson

jbarcena
Level 9
Level 9

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.

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

Getting Started

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: