Changes to UnityDb.bak & ReportDb.bak

Unanswered Question
Aug 31st, 2007
User Badges:

I have a Unity server running voicemail only on box 4.2(1) that is very low on disk space. Is it possible to change the location of the Report.Db.bak & UnityDb.bak files to a network drive?


Also would there be a problem to run the SqlWeeklyBackupJob twice a week say Wednesday & Sunday as this does shrink the database and reclaim disk space?


Thanks,


Lolu


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Ginger Dillon Fri, 08/31/2007 - 09:55
User Badges:
  • Blue, 1500 points or more

Hi -

Here is a forum entry I opened in 2005 for the same reason - http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.1dda1979

This process works really well! Another thought, move the *bak files to a different drive than Unity or your OS if possible (especially if Unity and OS on C drive). This past Sunday, I had a backed up mirror that failed to power up after application of a failed security update. Lost my OS due to critical files missing. I was able to recover the C drive from an earlier mirrored backup drive from August 5th. The OS and Unity came up OK, just was out of date by about 3 weeks! I was able to work with TAC to restore my UnityDb to current because I had the UnityDb.bak available on a different mirror set taken at 3:00 AM that morning. Went into SQL Enterprise Manager and restored the Unity database from the *bak file. The only other folder I needed to restore, which we did from our Veritas backup, was the Stream Files folder. Ran a DbWalker following this recovery with no errors. So having the UnityDb.bak file on a different drive saved my bacon big time.

Sincerely, Ginger

lolu.oshunbiyi@... Mon, 09/03/2007 - 06:38
User Badges:

Thanks Ginger, this is quite an old server that will be replaces shortly. Unfortunatley Unity & OS are on the the C drive and I do not have another drive to change the location to on the server itself, hence the question if there would be any complications using a network drive on another server?


Thanks,


Lolu

Ginger Dillon Tue, 09/04/2007 - 12:40
User Badges:
  • Blue, 1500 points or more

Hi Lolu -

I would be hesitant to use a networked drive. Just a thought - have you already taken steps to clean up your C drive disk files? For example, you can typically delete:

1. All $ntUninstall* and $NtServicePackUninstall* files older than the current month (these are OS and security update uninstall files) from the C:\Windows directory or C:\WinNT if running Windows 2000.

2. From the same directory, all KB*.log files

3. Check for any minidump files and delete if not needed (or copy these to networked drive and delete from C)

Ginger

lolu.oshunbiyi@... Wed, 09/05/2007 - 04:18
User Badges:

Ginger,


Thanks, there were a couple of the $ntUninstall files and I managed to reclaim around 200MB.


The problem is the ReportDb.bak grows to around 300MB and the UnityDb.bak to around 600MB by the end of the week, so I have scheduled the sql weekly backup to run on Wednesday as well as Sunday as it does a full backup and seems to get rid of the daily differential backups hence saving space.


Lolu


Actions

This Discussion