Backing up Enterprise Vault configured using SQL Availability Groups

book

Article ID: 100044397

calendar_today

Updated On:

Description

Error Message

0xe000848c - Unable to attach to a resource. Ensure that the selected resource exists and is online, and then try again. If the server or resource no longer exists, remove it from the selections.

V-79-57344-33932

Cause

The backups are failing with this error because the Backup Exec Enterprise Vault agent does not support SQL Availability Groups

Resolution

On the EV server(s) go to the path \program files\veritas\backup exec\raws and locate the BEDSEV.dll and add .old to change the extension. Then restart the Remote Agent service on this server / the servers.

 

Then download PsExec from here; https://docs.microsoft.com/en-us/sysinternals/downloads/psexec. Then extract the zipfile. For ease of use suggest to create folder at the root of a volume like C:\PsExec and copy and paste the extracted PsExec.exe here. From CMD open the exe once to accept the EULA! PsExec is a third party tool suggested for use with no further warranty. There may be other tools that offer same functionality.

 

On the Backup Exec server, log on with the Backup Exec System Account and in Backup Exec Settings | Network and Security, check the box for "Enable selection of user shares"

Still on the Backup Exec server create a new multi-server backup job consisting of the EV server(s) and the SQL Availability Group current active node

Note: If the active SQL Availability Group node changes the backup job will fail

When creating the selections for EV, choose the partitions that comes up as shares when expanding the EV server(s) as well as the index file path . Then select all the databases for the SQL selection.

 

The Backup Job has now been created and now we need to add the pre and post command to get EV in backup mode and then clear the backup mode.

 

In the Backup options click on Pre/Post commands

Example of command to run before the backup job starts;

C:\PsExec\psexec \\EV-EXCH.EV.local cmd /c "C:\Enterprise Vault Stores\Backup Scripts\EV_setbackupmode.bat"

This will get PsExec to call cmd on the EV server to run the script to set the backup mode. \\EV-EXCH.EV.local is the EV server i have used in this example. Replace this with the name (not alias) of your EV server. Also verify the path the the scripts and adjust accordingly if needed

Example of command to run at the end of the backup job;

C:\PsExec\psexec \\EV-EXCH.EV.local cmd /c "C:\Enterprise Vault Stores\Backup Scripts\EV_clearbackupmode.bat"

 

The bat files should be on your EV server. If you are unsure of path search for *.bat files. Example files is at the end of this article if you need to create the .bat files. Make sure to insert the EV server name, indicated by the  < >.

 

Use the checkbox to run these commands on this Backup Exec server and not on each remote server.

Also check:

Run job only if pre-command is successful

Run post-command only if pre-command is successful

Run post-command even if job fails

Let Backup Exec check the exit codes of the commands to determine if the commands completed successfully

 

Would recommend to test this first using CMD from the BE server to see that it executes ok before running the job. Just remember to also run the clearbackupmode if you just tried with the setbackupmode.

If it fails with access denied then add the roles detailed at the end of the article. You can also execute the cmd using the vault admin account. -u -p . This will work if it can connect ok and path is correct. After adding the roles run the cmd again without specifying -u and -p. See that setting and clearing the backup mode creates the events as detailed just below on the EV server.

 

To ensure the pre and post commands run as they should, run the job when it has been created and check on the EV server in the event logs | application and service logs | Veritas Enterprise Vault

Event ID 7060 & 41333

Successfully set Backup Mode on all the Vault Stores that are managed by the Storage Service on this computer

Successfully set backup mode on the following index locations.

Event ID 7081 & 41334

Successfully cleared Backup Mode from all the Vault Stores that are managed by the Storage Service on this computer

Successfully cleared backup mode from the following index locations

 

If you are using a dedicated logon account to backup EV, the Backup Exec System account will not have the rights to set and clear the backups modes. This is because PsExec passes the authentication from the application calling it. To correct this, logon to the EV server and use the EV powershell

 

Connect to the EV server as the "vault" user
Start the Enterprise Vault Administration Shell
Type the following commands:
Add-EVRbaRoleMember -identity "Storage Administrator" -Members ""
Add-EVRbaRoleMember -identity "Power Administrator" -Members ""

 

To ensure that this has been set correctly, check on the EV server in the event logs | application and service logs | Veritas Enterprise Vault

Event ID 41609

The following members were added to the role 'Storage Administrator':

The following members were added to the role 'Power Administrator':

 

Example of batch files

Set backup mode

C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files (x86)\Enterprise Vault\EVShell.psc1" -command "& {Clear-VaultStoreBackupMode -Name VaultSite -EVServerName -EVObjectType Site}"
C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files (x86)\Enterprise Vault\EVShell.psc1" -command "& {Clear-IndexLocationBackupMode -EVServerName -EVSiteName VaultSite}"

 

Clear backup mode

C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files (x86)\Enterprise Vault\EVShell.psc1" -command "& {Clear-VaultStoreBackupMode -Name VaultSite -EVServerName -EVObjectType Site}"
C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "C:\Program Files (x86)\Enterprise Vault\EVShell.psc1" -command "& {Clear-IndexLocationBackupMode -EVServerName -EVSiteName VaultSite}"

 

The content can be copied and saved as a .bat with a friendly name and the path you choose. Just make sure the name reflects its function and the path is the path you provide for PsExec to execute using the pre and post commands.

Issue/Introduction

When backing up Enterprise Vault (EV) that is configured with SQL Availability Groups for its databases, the backup job fails with error code 0xe000848c