Hyper-V VM running SQL

We have a VM running SQL2008. Backups are handled by Backup Exec 12.5 with Hyper-V Agent.

We are cannot backup the SQL VM unless the SQL and Agent services are shut down.

Running a backup with these services running generates VSS errors.

Basically, the backup fails during the initial snapshop process.

Thanks
LVL 1
Gig-A-DeeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
rscottvanConnect With a Mentor Commented:
Have a look at this Symantec article:
http://www.symantec.com/business/support/index?page=content&id=TECH74769

1. Stop the Microsoft Shadow Copy Provider &Volume Shadow Copy Service.

2. Export the contents of the HKLM\Software\Microsoft\EventSystem key to a .regfile.
Warning:Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.

3. Delete the HKLM\Software\Microsoft\EventSystem\{26c409cc-ae86-11d1-b616-00805fc79216}\Subscriptions key. (Do not delete the EventClasses key).

4. Restart the server.

5. Run the"VSSADMIN LIST WRITERS" command. (from an elevated command prompt)


This causes the VSS entries in the HKLM\Software\Microsoft\EventSystem\{26c409cc-ae86-11d1-b616-00805fc79216}\Subscriptions key to be rebuilt when the writers initialize.
0
 
rscottvanCommented:
Unless you use the SQL Agent for Backup Exec, you need to backup SQL with a SQL Maintenance Plan to a location that will be backed up later by the Hyper-V agent jobs.  In the Hyper-V agent job, exclude the folder where the live databases are located.
0
 
Gig-A-DeeAuthor Commented:
SHouldn't the Hyper-V Agent copy/backup the entire VHD file of the VM?
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Gig-A-DeeAuthor Commented:
We do in fact have the Backup Exec agent installed on this VM. This should also support GRT but it still fails and kills the VSS processes on the server.

Thanks
0
 
rscottvanCommented:
Can you post the Event Log entries for the VSS errors?
0
 
Gig-A-DeeAuthor Commented:
Backup- VRTSRV::\\EDGE-VM1.EDGE.LOCAL\Hyper-V?Store\Initial Store V-79-57344-65233 - AOFO: Initialization failure on: "VRTSRV::\\EDGE-VM1.EDGE.LOCAL\Hyper-V?Virtual?Machine\Edge-SQL". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).

Snapshot provider error (0xE000FED1): A failure occurred querying the Writer status.

Check the Windows Event Viewer for details.

Writer Name: Microsoft Hyper-V, Writer ID: {66841CD4-6DED-4F4B-8F17-FD23F8DDC3DE}, Last error: The VSS Writer failed, but the operation can be retried (0x800423f3), State: Failed during prepare snapshot operation (8).

Here's the backup exec log. I will post the app log shortly.

Thanks
0
 
Gig-A-DeeAuthor Commented:
There are zero errors in the Windows App log with the exception of the backup failing. No mention of VSS, etc.

Thanks
0
 
Gig-A-DeeAuthor Commented:
Performed the above procedure.

Please see attached screenshot.

Rescue--87667036-2011-04-10-10h5.jpg
0
 
rscottvanCommented:
I'll have to check the service history for our system when I get to the office in a couple hours - we had exactly the same issue...  it may have simply been upgrading to R2 and upgrading the agent on the SQL server that ultimately fixed this for us.
0
 
Gig-A-DeeAuthor Commented:
Fingers crossed!!!!!!!

Thanks
0
 
Gig-A-DeeAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.