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.

  • Modified Date:
  • Article ID:000088200

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

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)