02-02-2015 08:32 AM
Afternoon,
I have a w2k8 r2 Hyper V Host with 3 Virtual Servers. The VM's are also w2k8 r2 and each have a copy of SQL installed. We have all the licenses required.
We have a backup job that backs up the host and the 3 virtual machines, it completes with exceptions.
The exception on 1 of the SQL databases is "V-79-57344-38749 - Backup Exec was unable to prepare Microsoft SQL resources for Granular Recovery Technology (GRT) operations".
We can not restore the SQL database on this one virtual server without restoring the whole server and I can not understand why.
All the testing of credentials passes, SQL versions are all the same.. I'm at a bit of a loss.
Any advice appriciated.
Many thanks
Jon Buckley
02-02-2015 11:14 AM
Make sure the media server is updated and the remote agents pushed out to the remote servers.
What is the version of Backup Exec? see if this helps http://www.symantec.com/docs/TECH197907
02-02-2015 11:22 AM
Check below Jon:
http://www.symantec.com/business/support/index?page=content&id=TECH201411
Thanks!
02-02-2015 11:28 AM
Jon,
On the 1 server that's having an issue, are all the databases inside of SQL online?
Are you able to backup that SQL instance with a regular backup (not using the Hyper-V agent)?
02-04-2015 06:17 AM
Hi,
Thanks for your advise so far, I can confirm the following: -
Version: 14.0 Rev. 1798 (64 Bit).
All the required licenses are licensed and Installed.
Service Pack 4 is now available.
All virtual hard disks are fixed.
Disks are all MBR.
Remote Agent is 14.0.1798.
If I create a new job by right clicking on the server (that is having the problem) and select backup I can select just MSSQL, the job fails with the following error: -
V-79-57344-65085 - There was a problem running the DBCC.
Database 'SQLDatabase1' cannot be opened because it is offline.
There are approx 7 databases, 3 fail with the above message the other complete with a warning about the type of recorvey mode which is acceptable.
If an SQL Database is offline would that stop GRT backups / restores on our original backup job which includes selecting the host and all the virtual machines running on it.
Thanks
02-04-2015 07:08 AM
http://www.symantec.com/business/support/index?page=content&id=TECH126737