?
Solved

Hyper-V VM running SQL

Posted on 2011-03-24
11
Medium Priority
?
530 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:Gig-A-Dee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 10

Expert Comment

by:rscottvan
ID: 35215460
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
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35219850
SHouldn't the Hyper-V Agent copy/backup the entire VHD file of the VM?
0
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35278114
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
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 
LVL 10

Expert Comment

by:rscottvan
ID: 35281169
Can you post the Event Log entries for the VSS errors?
0
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35295096
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
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35295324
There are zero errors in the Windows App log with the exception of the backup failing. No mention of VSS, etc.

Thanks
0
 
LVL 10

Accepted Solution

by:
rscottvan earned 2000 total points
ID: 35298621
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
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35361888
Performed the above procedure.

Please see attached screenshot.

Rescue--87667036-2011-04-10-10h5.jpg
0
 
LVL 10

Expert Comment

by:rscottvan
ID: 35366712
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
 
LVL 1

Author Comment

by:Gig-A-Dee
ID: 35368151
Fingers crossed!!!!!!!

Thanks
0
 
LVL 1

Author Closing Comment

by:Gig-A-Dee
ID: 36410991
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From Coral's  "So You Want To Play With Computers" Series A bit of background first, so this story will make a little sense. One day, probably because he needed a good laugh, Finagle hooked me up with a church to upgrade/run their Media Booth.…
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Suggested Courses
Course of the Month14 days, 14 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question