Guest

Cisco Unity

Unity SQL Backup Issues Troubleshooting

Document ID: 71986



Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
The scheduled database backup does not work on Cisco Unity 4.0(5) and earlier and creates an error message in the application log
Solutions
      Solution 1
      Solution 2
      Solution 3
Remote Unity Backup Fails When Remote Server is in a Different Domain
      Solution
DiRT Backup Fails with the Error: (error):70 (Permission denied) in procedure bAccountHasMailstoreRights of Form frmMain
      Solution
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

When you back up and restore a Cisco Unity server (and one or more Exchange servers) you need to consider the same issues involved when you back up and restore any other system. This document discusses how to troubleshoot a Cisco Unity SQL backup failure.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on Cisco Unity 4.0(5) and earlier.

Note: Disaster Recovery Tools (DiRT) backup is the only Cisco supported Backup and Restore Tool for a Cisco Unity Server.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to Cisco Technical Tips Conventions for more information on document conventions.

The scheduled database backup does not work on Cisco Unity 4.0(5) and earlier and creates an error message in the application log

The nightly Cisco Unity database backup schedule does not work on Cisco Unity server 4.0(5) and earlier. The scheduled backup fails and the application log shows this error message:

SQLSERVERAGENT 208 SQL Server Scheduled Job
	 'SqlNightlyBackupJob' (0xDD76B87067B64E4EA8BE7C8EE0B05F59) - Status: Failed -
	 The Job was invoked by Schedule (Nightly UnityDb Backup Schedule). The last
	 step to run was step 2 (BackupUnityDbLog).

Refer to Cisco bug IDs CSCsa95341 ( registered customers only) and CSCdv82394 ( registered customers only) for more information on this issue.

Solutions

This issue occurs in Cisco Unity 4.0(5) and earlier versions where the Cisco Unity installation account has had privileges revoked or the account is disabled. The hard drive might not be full, but the Unity database and/or log files exceed 100 MB for every 10 K Unity subscribers in the environment. This issue is fixed in Cisco Unity 4.1(1) and later. In order to resolve this issue, you can either upgrade to Cisco Unity 4.1(1) or later or perform one of the solutions discussed in this document.

Solution 1

Complete these steps in order to resolve this issue:

  1. Go to the Cisco Unity server and choose Start > Programs > Microsoft SQL Server > Enterprise Manager. If MSDE is not installed, refer to Installing Administration Software for MSDE 2000.

  2. Click Microsoft SQL Servers > SQL Server Group > <UnityserverName> > Databases, right-click on UnityDb and choose Properties.

  3. Go to the Options tab and change the Recovery Model to Full if it is set to Simple.

    unity-sql-backup-ts-1.gif

  4. Click Microsoft SQL Severs > SQL Server Group > Local Server > Management > Sql Server Agent > Jobs. If the jobs failed in the past, there is a red X on SqlNightlyBackupJob and SqlWeeklyBackupJob.

  5. Right-click on SqlWeeklyBackupJob and choose Start Job.

  6. Wait a few minutes and then press the <F5> key in order to refresh the status.

  7. Repeat steps 5 and 6 for SqlNightlyBackupJob.

Solution 2

Custom SQL backup scripts can also fail if the Cisco Security Agent for Cisco Unity version 1.1(4) or earlier is installed and runs during backup. If the Cisco Security Agent for the Cisco Unity Microsoft SQL protection rules are violated when a user performs custom SQL backup procedures or DiRT backup, the backup does not complete. The problem occurs if the process that performs the backup does not have the correct Cisco Security Agent file access control permissions for the backup target location.

Versions of the Cisco Security Agent for Cisco Unity later than release 1.1(4a) include a rule that identifies any directory named SQLBackups as a sandbox directory that is excluded from Cisco Security Agent for Unity SQL protection rules. So, an upgrade to Cisco Security Agent for Cisco Unity to a version later than 1.1(4a) solves this issue. You can download the latest version of Cisco Security Agent for Cisco Unity from the Software Download ( registered customers only) page.

You can also resolve this issue if you perform any of these steps:

  • For Cisco Security Agent for Cisco Unity versions 1.1(4a) and earlier, the Cisco Security Agent can be disabled before you run any custom backup procedures, then re-enable the Cisco Security Agent after the backup is complete.

  • If this problem is encountered with a version of the Cisco Security Agent for Cisco Unity that is later than version 1.1(4a), change the custom backup target location, or DiRT backup target location, to a path that includes a directory named SQLBackups. For example, backup destination target paths that match the sandbox rule include C:\SQLBackups\, D:\<directory>\SQLBackups\<name>\, and \\backupserver\SQLBackups\.

Solution 3

You need to make sure that the account used by the DiRT backup and by the SQL backup is the same. If not, you can manually change the owner of the backup jobs in order to resolve this issue. Complete these steps:

  1. Open SQL Enterprise Manager.

  2. Expand Microsoft SQL Servers > SQL Server Group > <UnityserverName> > Security and choose Logins.

  3. Right-click on Logins and choose New Login.

  4. In the General Tab, click the ... button next to the Name field and choose the Unity Directory Service(dirsvc) account from the domain user listing. Then click Add and OK.

    unity-sql-backup-ts-2.gif

  5. Go to the Server Roles tab and check System Administrators.

    unity-sql-backup-ts-3.gif

  6. Go to the Database Access tab and check Permit for UnityDb, ReportDb and UnityDistributionDb (if Failover is installed). Then check db_backupoperator for Permit in Database Role and click OK.

    unity-sql-backup-ts-4.gif

  7. Click Microsoft SQL Severs > SQL Server Group > <UnityserverName> > Management > Sql Server Agent > \Jobs.

  8. Right-click on SqlNightlyBackupJob and choose Properties. Then right-click on SqlWeeklyBackupJob and choose Properties again.

  9. From the Owner drop-down, choose the user that you just added and click OK.

Note: This issue can result in low disk space on the server. You need to shrink the Cisco Unity databases in this situation. Refer to Shrink the Cisco Unity Database Configuration Example for information on how to shrink the Cisco Unity database.

Remote Unity Backup Fails When Remote Server is in a Different Domain

When the Cisco Unity backup is performed to a remote server which is located in a different domain, the backup fails. The backup is created, but the backup cannot be moved to the remote location. If you create a backup locally and then create a job to move the backup file from the local server to the remote server, it works fine if the job is run on the server's console, but fails when it runs as a scheduled job.

Solution

Complete these steps in order to resolve the issue:

  1. Create a mapped drive. The mapped drive is available only while logged in the server.

  2. Create your scheduled job to move the file to the remote location.

  3. The scheduled job works as long as the account is logged to the server, due to the availability of the mapped drive. This means that you need to be logged to the server.

DiRT Backup Fails with the Error: (error):70 (Permission denied) in procedure bAccountHasMailstoreRights of Form frmMain

When you run the DiRT backup, you receive a message that asks if you ran DBWalker. When you press ok, this error is received:

(error):70 (Permission denied) in procedure bAccountsHasMailStoreRights of Form frmMain

Followed by this error:

(error):52 (Bad file name or number) in procedure bAccountHasMailStoreRights
of Form frmMain

Solution

One of the most common causes of this error is the account that is running DiRT does not have the right permissions. In order to run the backup successfully, make sure that the account has the right permissions as mentioned in Configuring Permissions for DiRT with Exchange .

NetPro Discussion Forums - Featured Conversations

Networking Professionals Connection is a forum for networking professionals to share questions, suggestions, and information about networking solutions, products, and technologies. The featured links are some of the most recent conversations available in this technology.
NetPro Discussion Forums - Featured Conversations for Voice
Service Providers: Voice over IP
Voice & Video: Voice over IP
Voice & Video: IP Telephony
Voice & Video: IP Phone Services for End Users
Voice & Video: Unified Communications
Voice & Video: IP Phone Services for Developers
Voice & Video: General

Related Information



Updated: Feb 05, 2007Document ID: 71986