<div>
<div class="content wysiwyg-content">
I have two physical DB boxes that I am moving to Hyper-V VM's.<br />
Each box is running server 2003 with the latest service packs. &nbsp;One box is running SQL2000 and the other box is running an older DB app in which to backup:<br />
&nbsp;the DB service has to be shut down,<br />
&nbsp;then the Log and DB copied to a location,<br />
&nbsp;and then service restarted.<br />
<br />
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.<br />
<br />
If this won't work, I am open to other solutions.<br />
<br />
Thanks<br />
-SM
</div>
</div>


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

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.