I recently Upgraded a Unity 3.0 Voicemail only Server to Unity 4.2.1 and started to see the error below:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
SQL Server Scheduled Job 'SqlNightlyBackupJob' (0xDA8140E55052E143B09714420A44CDA8)
- Status: Failed - Invoked on: 2006-10-18 02:00:00 - Message: The job failed.
The Job was invoked by Schedule 8 (Nightly UnityDb Backup Schedule).
The last step to run was step 1 (DifferentialUnityDbBackup).
I then checked the Job History and found this for step 1 of the Job::
Executed as user: NT AUTHORITY\SYSTEM. No entry in sysdevices for backup device 'UnityDbDump'. Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
I then checked further and found that there are no Backup devices UnityDbDump and also ReportDBDump. I also checked what other steps are in the Job and found this:
I was about to attempt to create the backup devices before I also realised that the ReportDb database is missing. I presume the Job would still fail If I did this. Any help as to how to resolve this would be appreciated.
Re: SqlNightlyBackupJob Failing 3.0 to 4.2.1 Upgrade
After more investigation I found that the Report Database files still existed on the server. I then reattached the Database, created the ReportDB and UnityDB backup devices ran the SqlWeeklyBackupJob then the SqlNightlyBackupJob and all seems ok.
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.