Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Unity 5 issue

what are the possible causes of C drive getting completely full on Unity 5? How to troubleshoot?

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Unity 5 issue

Ashok,

Both the database files and the transaction logs are in the folder:

C:/Program Files\Microsoft SQL Server\MSSQL\data

So that is the folder in question.

Transaction logs end with .ldf

Database files end with .mdf

On the new partition, create a similar folder structure with the only difference being the drive letter.

Hope this helps.

Regards,

Michael.

6 REPLIES
Cisco Employee

Re: Unity 5 issue

Hi Ashok,

Here are some common ones:

In a VM deployment with Exchange onbox, when circular logging is disabled, transaction log files might take up a large amount of available space.

http://www.cisco.com/en/US/docs/voice_ip_comm/unity/404/maintenance/guide/ex/mg0300.html#wp1072840

Depending on the type of server, there are recommended best practices around which drives to install which components such as the SQL db, partly to ensure the best use of the available drives. Here's that documentation for Unity 5.0:

http://www.cisco.com/en/US/docs/voice_ip_comm/unity/5x/installation/guide/umexfo/5xcuigumefo020.html#wp1731846

Also look for upgrade files, OS patches, SP's ES's that are stored on the drive but have been installed and can therefore be deleted.

Hope this helps.

Regards,

Michael.

New Member

Re: Unity 5 issue

Thanks Michael,

I found out that the SQL logs are taking up too much space on C drive. So I am copying the C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder to another partition. Then I will shrink the database using the following commands:

C:\>osql -E

1>use unitydb

1>go

1>backup log unitydb with no_log

2>go

1>dbcc shrinkdatabase(unitydb)

2>go

1>exit

C:\>osql -E

1>use ReportDB

1>go

1>backup log ReportDB with no_log

2>go

1>dbcc shrinkdatabase(ReportDB)

2>go

1>exit

Thing is I want to preserved the logs, so hope moving them to another partirion will preserve them. I hope my analysis is correct.

Cisco Employee

Re: Unity 5 issue

Hi Ashok,

Your analysis sounds right. If you just move them to another partition, they should be preserved there as long as they are not acted upon.

Will the log files continually be transferred to the new partition in the future? If the new partition has sufficient space, you could also move SQL databases there permanently as well. Those steps are documented here, in addition to the steps for shrinking the database, which you referenced:

Moving the Data Store Databases and Transaction Logs

http://www.cisco.com/en/US/docs/voice_ip_comm/unity/5x/installation/guide/umexnofo/5xcuigumenofo080.html#wp1664607

Shrink the Cisco Unity Database Configuration Example

http://www.cisco.com/en/US/products/sw/voicesw/ps2237/products_configuration_example09186a008075ba49.shtml

Regards,

Michael.

New Member

Re: Unity 5 issue

Michael,

Could you please suggest the relevant folders to be moved? I just want to ensure that I am not missing out on anything.

Regards,

Ashok.

Cisco Employee

Re: Unity 5 issue

Ashok,

Both the database files and the transaction logs are in the folder:

C:/Program Files\Microsoft SQL Server\MSSQL\data

So that is the folder in question.

Transaction logs end with .ldf

Database files end with .mdf

On the new partition, create a similar folder structure with the only difference being the drive letter.

Hope this helps.

Regards,

Michael.

New Member

Re: Unity 5 issue

Hi Michael,

Thanks a lot for your help. Have a nice evening.

Regards,

Ashok.

157
Views
10
Helpful
6
Replies
CreatePlease to create content