Hyper-V: SQL GRT job completes with exception V-79-57344-38749 - Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations.

  • Article ID:100029069
  • Modified Date:
  • Product(s):

Problem

Hyper-V: SQL GRT job completes with exception V-79-57344-38749 - Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations.

Solution

Workaround:

Backup SQL Databases using Remote Agent for Windows Server (RAWS)

Solution:

1. Change the SQL server's disk ID from something so simple and potentially common like 0x1 to something that is more unique.

2. Try using a W2k8 R2 media server

 

Applies To

Disk signature of the disk hosting SQL database is "Disk ID: 00000001"
 

DISKPART> list volume

  Volume ###  Ltr  Label        Fs     Type        Size     Status     Info
  ----------  ---  -----------  -----  ----------  -------  ---------  --------
  Volume 0     D                       DVD-ROM         0 B  No Media
  Volume 1         RECOVERY     NTFS   Partition   3072 MB  Healthy    System
  Volume 2     C   OS           NTFS   Partition    133 GB  Healthy    Boot
  Volume 3     E   SQLData      NTFS   Partition    278 GB  Healthy
  Volume 4     F   SQLLogs      NTFS   Partition    278 GB  Healthy
  Volume 5     G   SQLTemp      NTFS   Partition    278 GB  Healthy

DISKPART>

DISKPART> select disk 1

Disk 1 is now the selected disk.

DISKPART> unique disk

Disk ID: 00000001

Was this content helpful?

Get Support