Unity Disk Space

Unanswered Question
Oct 30th, 2008

I am running out of space on my Unity Hard Drive. What is the procedure to Truncate the Reportdb. I am running on windows server 03.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
jbarcena Thu, 10/30/2008 - 17:05

You can use the following SQL commands to shrink the Unity DB:

C:\osql -E

1>use UnityDb


1>backup log UnityDb with no_log


1>dbcc shrinkdatabase (unitydb)




You can use the same commands for teh ReportDB just replace the Unitydb with Reportdb

Also the transactional logs fill the hard drive so keep an eye on those files, you can delete them manually without any problem, to locate them follow this link:


Finally keep in mind that Unity needs at leat 400 MB of free space to run correctly.



This Discussion