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.

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.

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.

Hi Michael,

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

Regards,

Ashok.