• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1030
  • Last Modified:

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

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.

Thanks
-SM
0
smantz
Asked:
smantz
3 Solutions
 
Sushil SonawaneCommented:
Backup Exec 12.5 can backup/restore complete VMs.  It can also do file level restore of VMs

OR

For another backup soluation, please refer below link.

(http://www.veeam.com/microsoft-hyper-v-server-backup-recovery-replication.html)

(http://social.technet.microsoft.com/Forums/en-US/winserverhyperv/thread/7aabf41a-a408-47e7-8bec-d586e01940fe)
0
 
Svet PaperovIT ManagerCommented:
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.
0
 
Pradeep DubeyConsultantCommented:
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:

http://zenithinfotech.com/Solutions/backup%20and%20disaster%20recovery.aspx
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.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now