Best Practice for Backup of SQL Server on Hyper-V machine

Posted on 2011-10-12
Last Modified: 2012-05-12
I recently virtualized a SQL Server 2005 server onto a Hyper-V system.  The guest OS is Windows Server 2008 R2.  

I've got a Hyper-V Remote Agent for Backup Exec 2010 R3 that backs up the Hyper-V host and all its guest OSs.  It doesn't allow for granular restores of SQL databases, but I am running the native SQL Server backups in a maintenance plan.  

The old physical server had been using a SQL Server Remote agent, which is now available to be moved to the virtualized SQL Server.  It does allow for granular restores.

So, I'm looking for the best combination of my resources for backing up my virtualized SQL Server.  Your suggestions?
Question by:anordquist
    LVL 38

    Accepted Solution

    As I've ha Ba experience with backup software and SQL, I've sinced moved to a simple sqlcmd script that creates .bak files of my databases and I let the backup software back those up. Since they are nice unlocked files, I don't need anything special, any software can do it.
    LVL 23

    Assisted Solution

    by:Racim BOUDJAKDJI
    SQL Backups can be done independently from system backups.  SQL backups guarantee application transaction coherent databases at restore time which can not be seen from the perspective of the system.  At restore time, restore the most recent system backup  then restore the nearest SQL backup.

    Hope this helps...

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    #Citrix #Citrix Netscaler #HTTP Compression #Load Balance
    #Citrix #XenApp #Citrix Scout #Citrix Insight Services #Microsoft VMMAP #Microsoft ADEXPLORE #Microsoft RAMMAP #Microsoft TCPVIEW #Microsoft AUTORUNS #Microsoft PROCESS EXPLORER #Microsoft PROCESS MONITOR
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
    This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now