Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

DiRT Backup of the Cisco Unity 4.x fails with a SQL Error (error) in cmbBackup routine:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\Server\d$\unitybkp\UnityDBBackUp.sql'. Device error or device off-line

Core Issue

During the execution of a scheduled backup, Cisco Unity runs into this SQL error:

2007 3:00:36 AM: (error) in cmbBackup routine:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device '\\Server\d$\unitybkp\UnityDBBackUp.sql'. Device error or device off-line. See the SQL Server error log for more details.[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. number= 0.

There are two possible causes which render this issue.

  1. When the backup is done with the Cisco Security Agent turned on.

  2. The two-hop SQL backup method is not used.

Resolution

In order to resolve this issue while backing up, disable the CSA and enable it when the backup is complete and check the option SQL 2-hop under the backup option.

The actual backup of the SQL data for the main Cisco Unity database and, optionally, the reports database is done with the SQL services.  As such, the permissions to write files to the target directory are limited by the account under which the SQL services run.  If your site uses the local system account for these services, then if you write the SQL backup data to an off box location, it fails.  Further, you use a domain account for the SQL services but do not want to grant read/write permissions to the off box location, then the SQL backup portion fails as well.

This is a fairly common scenario so a simple mechanism to work around it is provided.  First, do the SQL backup to a local drive. Move the backed up database files to the off box target with the use of the account DiRT backup under which it runs, and then delete the local copies of the backup files.  This is called the two hop method.

Check the Use  two hop  method for backing up SQL data check box in order to use this method and then provide a local target to use.  Be sure to use a local drive where there is enough space to do the backup, for example, the SQL tables can be large. 

Refer to Disaster Recovery Backup and Restore for more information.

928
Views
0
Helpful
0
Comments