Solved

Hyper-V VM running SQL

Posted on 2011-03-24
11
529 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

695 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