'Database system error' when browsing backup images for Exchange, SharePoint or Microsoft SQL Server

'Database system error' when browsing backup images for Exchange, SharePoint or Microsoft SQL Server

Article: 100045718
Last Published: 2019-06-11
Ratings: 0 0
Product(s): NetBackup

Problem

The error occurs when VMware assets with applications (Microsoft SQL Server, Exchange, SharePoint) are protected using a protection plan. The protection plan option selected: ‘Allow the restore of application data from virtual machine backups’.

Error Message

  • Exchange : database system error
  • Microsoft SQL Server: Error encountered trying to read database images
  • SharePoint : database system error

Cause

VMware assets with applications (Microsoft SQL Server, Exchange, SharePoint) are protected as stated above and the backup is cataloged with the VM UUID instead of the client name or primary VM identifier.

Note that the primary VM identifier is not used to catalog the backup. That is, if you configured an intelligent group for VM assets with a particular displayName, the application backup uses the VM UUID to catalog the backup.

Solution

Restoring Microsoft SQL Server databases from a VMware backup that is protected using a protection plan.

The following steps describe how to restore a Microsoft SQL Server database from a full VMware backup when the VM containing Microsoft SQL Server is protected using a protection plan.

To restore a Microsoft SQL Server database from a VMware backup created from a protection plan:

  • Sign in to the NetBackup web user interface or NetBackup Administration console
  • On the Jobs node or Activity monitor, find the backup job for the VM.
  • The VM backup is catalogued with a unique identifier (UUID). In the jobs details, locate and copy the UUID(Ex: 50364a7e-928d-f11c-85f3-3e54ef77ae4a).
  • In the NetBackup Administration Console, open Host properties > Master Server > Distributed Application Restore Mapping. Map the UUID to the VM hostname.

Application host        Component host
VM UUID            VM hostname

  • Use the VM UUID as source client to browse the image in NetBackup SQL Client > NetBackup MS SQL Client GUI and perform the restore.

Restoring Exchange data from a VMware backup that is protected using a protection plan.

The following steps describe how to restore an Exchange data from a full VMware backup when the VM containing Exchange is protected using a protection plan.

  • Sign in to the NetBackup web user interface or NetBackup Administration console
  • On the Jobs node or Activity monitor, find the backup job for the VM.
  • The VM backup is catalogued with a unique identifier (UUID). In the jobs details, locate and copy the UUID(Ex: 50364a7e-928d-f11c-85f3-3e54ef77ae4a).
  • In the NetBackup Administration Console, open Host properties > Master Server > Distributed Application Restore Mapping. Map the UUID to the VM hostname.

Application host        Component host
VM UUID            VM hostname

  • Use the VM UUID as source client to browse the image in NetBackup SQL Client > NetBackup MS SQL Client GUI and perform the restore.

Restoring Exchange data from a VMware backup that is protected using a protection plan.

The following steps describe how to restore an Exchange data from a full VMware backup when the VM containing Exchange is protected using a protection plan.

  • Sign in to the NetBackup web user interface or NetBackup Administration console
  • On the Jobs node or Activity monitor, find the backup job for the VM.
  • The VM backup is catalogued with a unique identifier (UUID). In the jobs details, locate and copy the UUID(Ex: 50364a7e-928d-f11c-85f3-3e54ef77ae4a).
  • In the NetBackup Administration Console, open Host properties > Master Server > Distributed Application Restore Mapping. Map the UUID to the VM hostname.

Application host        Component host
VM UUID            VM hostname

  • For a restore of an Exchange standalone server, you must select the source client name i.e. the UUID to browse the image contents.
  • Select a destination client name that NetBackup recognizes. The destination client name must be a network name or computer name. This name must allow NetBackup to connect to the NetBackup client.
  • For a restore of Exchange DAG select the DAG name as source client and destination client. We need to map the UUID to all the nodes(hostnames) in the given Exchange deployment.

Restoring SharePoint data from a VMware backup that is protected using a protection plan.

The following steps describe how to restore a SharePoint farm data from a full VMware backup when the VM containing SharePoint is protected using a protection plan.

  • Sign in to the NetBackup web user interface or NetBackup Administration console
  • On the Jobs node or Activity monitor, find the backup job for the VM.
  • The VM backup is catalogued with a unique identifier (UUID). In the jobs details, locate and copy the UUID(Ex: 50364a7e-928d-f11c-85f3-3e54ef77ae4a).
  • In the NetBackup Administration Console, open Host properties > Master Server > Distributed Application Restore Mapping. Map the UUID to the hostnames of the SharePoint Front end server and SQL server in the farm.

    Application host        Component host
    VM UUID                VM hostname

Select the SharePoint front end servers hostname as source client and destination client to browse the image and perform restore.

Applies to

NBU 8.2

References

Etrack : 3979554

Was this content helpful?