09-13-2005 02:19 PM - edited 03-18-2019 05:03 PM
I am starting a backup to perform an upgrade from 4.0(3) to 4.0(5) and i have been looking over everything. The initial DBWalker went fine, but i had an error in the eventlog that states "error event id 17055 + 3041: BACKUP failed to complete the command BACKUP LOG UnityDb TO UnityDbDump". I know that this is related to the SQL DB, but I don't know if this is a mission critical that gets fixed before the upgrade, as I am not sure if the error is streaming from the server itself or the backup system. I have been searching both Cisco and MS, but no one can isolate this down. Has anyone run into this before? And if so, is this a critical error or is there a workaround?
Solved! Go to Solution.
09-13-2005 04:34 PM
Open Enterprise Manager
Right-Click on UnityDb database and select Properties
Click on the OPTIONS-tab
Change the Recovery model from SIMPLE to FULL.
Go to the Nightly backup job, right-click on it select "start job". Check the app logs after a few minutes
09-13-2005 02:31 PM
Those are failing nightly/weekly backups and yeah, you'll probably want to fix those - several threads on that out here, check out this one for details:
09-13-2005 03:17 PM
Find out if there is a problem with UnityDbDump
Open Enterprise Manager
Drill down to Management, Backup.
Right click on UnityDbDump
View Contents (I think you are going to see some sort of corruption)
**********************************
If UnityDbDump is corrupted, you could create a new "backup device".
1) Open Enterprise Manager
2) Drill down to Management, Backup.
3) Right-click, Select New BACKUP Device. Create the device - for instance TEST (you can name it anything you want).
4) Right-click on SqlWeeklyBackupJob, select the Steps-tab
a) Edit step1 FullUnityDbBackup
change "BACKUP DATABASE UnityDb TO UnityDbDump ..." to "BACKUP DATABASE UnityDb TO TEST
..."
b) Edit step2 BackupUnityDbLogWeekly "BACKUP LOG UnityDb TO UnityDbDump" to "BACKUP LOG
UnityDb TO TEST"
5) Right-click on SqlNightlyBackupJob, select the Steps-tab
a) edit DifferentialUnityDbBackup
change "BACKUP DATABASE UnityDb TO UnityDbDump......" to "BACKUP DATABASE UnityDb TO TEST
...... "
09-13-2005 04:29 PM
OK, I have been able to see all of the data ok, and it is giving me the error "Executed as user: CO\COUNITY$. The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. [SQLSTATE 42000] (Error 4208) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed." Will the steps listed above be able to change this?
09-13-2005 04:34 PM
Open Enterprise Manager
Right-Click on UnityDb database and select Properties
Click on the OPTIONS-tab
Change the Recovery model from SIMPLE to FULL.
Go to the Nightly backup job, right-click on it select "start job". Check the app logs after a few minutes
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide