Unity 5 issue

Answered Question
Sep 9th, 2008
User Badges:

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

Correct Answer by Michael Owuor about 8 years 9 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Loading.
Michael Owuor Tue, 09/09/2008 - 03:00
User Badges:
  • Cisco Employee,

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.

singh-ashok Tue, 09/09/2008 - 03:17
User Badges:

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.

Michael Owuor Tue, 09/09/2008 - 03:54
User Badges:
  • Cisco Employee,

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.

singh-ashok Tue, 09/09/2008 - 04:16
User Badges:

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.

Correct Answer
Michael Owuor Tue, 09/09/2008 - 06:15
User Badges:
  • Cisco Employee,

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.

singh-ashok Wed, 09/10/2008 - 05:40
User Badges:

Hi Michael,

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


Regards,

Ashok.

Actions

This Discussion