Backing up non VSS Databases on Hyper-V VM's

Posted on 2012-09-01
Last Modified: 2012-09-03
I have two physical DB boxes that I am moving to Hyper-V VM's.
Each box is running server 2003 with the latest service packs.  One box is running SQL2000 and the other box is running an older DB app in which to backup:
 the DB service has to be shut down,
 then the Log and DB copied to a location,
 and then service restarted.

I was wondering if I can have consistent backups of the older DB's if I use a Hyper-V aware backup solution and backing up the VM's.

If this won't work, I am open to other solutions.

Question by:smantz
    LVL 18

    Assisted Solution

    by:Sushil Sonawane
    Backup Exec 12.5 can backup/restore complete VMs.  It can also do file level restore of VMs


    For another backup soluation, please refer below link.


    LVL 20

    Accepted Solution

    Hyper-V does the backup by taking a snapshot of the Virtual machine. With Windows Server 2003 R2 VM this is done without stopping the VM or putting it in saved stated. But, it does not allow further iteration with the OS of the VM.

    You could, however, get consistent backup by stopping or putting the virtual machines in save state before taking the backup. You could use PowerShell and wbadmin to do that.

    But, there is another however: Hyper-v backup takes a snapshot of the whole VM and generally is not very useful to restore corrupted databases. For example, there is no way to restore the database and play the transaction logs (oh, yes, since the VM will be stooped the transaction logs will not be truncated is case of Hyper-v level backup).

    So, my answer is no, oh should not use Hyper-V backup for those virtual machines.
    LVL 11

    Assisted Solution

    by:Pradeep Dubey
    If I have same issue I'll prefer Zenith backup solution, which have capability to take database backup (non VSS aware).
    See the below link for more information:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now