I have to go and fix an issue with a client Unity server that is running out of space due to what I believe to be it partitioned incorrectly. Any ideas or steps to doing this the quickest way.
- posted
18 years ago
I have to go and fix an issue with a client Unity server that is running out of space due to what I believe to be it partitioned incorrectly. Any ideas or steps to doing this the quickest way.
You may wish to investigate Microsoft's Reclaiming Disk Space for the Information Store:
------------------------------------------
Unity server where the SQL transaction log ( UnityDb_log.LDF ) has grown to over 4.5GB and caused their system to run out of disk space on that partition.
Shrink the transaction log down to a more reasonable size and prevent this kind of problem from happening again:
Open Enterprise Manager, right-click on the database, select properties.
Go to the Options tab and make sure that Simple Recovery is selected for Recovery Models. ( If Full Recovery is selected, then it would not be possible to truncate the file which is the next step ).
Then right-click on the database again and select Shrink Database. On the "Shrink Database" window, Click on FILES button.
Select the transactional log from DATABASE FILE, and select the option TRUNCATE FREE SPACE FROM THE END OF THE FILE on the SHRINK ACTION choices. After shrinking, the Current Size and Space Used should decrease significantly.
Sincerely,
Brad Reese BradReese.Com Cisco Repair Service Experts
Cabling-Design.com Forums website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.