Virtual Machines disappeared, readded and data is missing?

Here it goes. I believe this was related to Trend micro manual scan since
everything had been fine for the last 4 months. I have a sql server in
hyper-v along with 4 other vm's performing various functions. After a
reboot of the server, all of these vms disappeared from the vm console. I
crated "new" virtual machines using the vhd file of the orginals that were
there. However, I have noticed that the sql server databases, mainly
Sharepoint database, has no data that I have been putting in it for the last
4 months. Where did this go? I thought all data resided on the vhd. I
don't believe I had a snapshot of the sql server although there may have
been one. If these are only used to return a machine to a previous point in
time then this should not have mattered. Any insite would be greatly
appreciated. I dread the though of having to recreate all of this work.
One other note, the sql server had a second virtual disk where all of the
databases reside.

Thanks.


BTW, there was not backup as the organization can't afford it at the moment
and drive space is very limited. I know what you are going to say about
that.

On Mon, 28 Dec 2009 02:41:25 -0500, "JackH"
<grandam010nospam@gmail.com> wrote:

>BTW, there was not backup as the organization can't afford it at the moment
>and drive space is very limited. I know what you are going to say about
>that.
>
The cost of lost data is *way higher* than any disk you can buy to
store a backup on!
You can get 500 Gb of disk storage for next to nothing these days....

--

Bo Berglund (Sweden)

I know. Trying to convince the execs of that seems almost impossible.

BTW, I did get everything back. That was close.


"Bo Berglund" <boberglund@myotherhome.sec> wrote in message
newsqugj5126ri0s6vttji1eu9icjp7pg7u7t@4ax.com...
> On Mon, 28 Dec 2009 02:41:25 -0500, "JackH"
> <grandam010nospam@gmail.com> wrote:
>
>>BTW, there was not backup as the organization can't afford it at the
>>moment
>>and drive space is very limited. I know what you are going to say about
>>that.
>>
> The cost of lost data is *way higher* than any disk you can buy to
> store a backup on!
> You can get 500 Gb of disk storage for next to nothing these days....
>
> --
>
> Bo Berglund (Sweden)

When you recreated the VMs, did you include the second VHD for the SQL VM?
And did you verify that drive letters, etc, were the same as original?

And I agree with Bo. A USB backup drive is cheap insurance.

--
Charlie.
http://msmvps.com/blogs/russel




"JackH" <grandam010nospam@gmail.com> wrote in message
news:OI9pyE5hKHA.2164@TK2MSFTNGP02.phx.gbl...
> Here it goes. I believe this was related to Trend micro manual scan since
> everything had been fine for the last 4 months. I have a sql server in
> hyper-v along with 4 other vm's performing various functions. After a
> reboot of the server, all of these vms disappeared from the vm console. I
> crated "new" virtual machines using the vhd file of the orginals that were
> there. However, I have noticed that the sql server databases, mainly
> Sharepoint database, has no data that I have been putting in it for the
> last 4 months. Where did this go? I thought all data resided on the vhd.
> I don't believe I had a snapshot of the sql server although there may have
> been one. If these are only used to return a machine to a previous point
> in time then this should not have mattered. Any insite would be greatly
> appreciated. I dread the though of having to recreate all of this work.
> One other note, the sql server had a second virtual disk where all of the
> databases reside.
>
> Thanks.
>
>
> BTW, there was not backup as the organization can't afford it at the
> moment and drive space is very limited. I know what you are going to say
> about that.
>

On Mon, 28 Dec 2009 02:41:25 -0500, "JackH"
<grandam010nospam@gmail.com> wrote:

>Here it goes. I believe this was related to Trend micro manual scan since
>everything had been fine for the last 4 months. I have a sql server in
>hyper-v along with 4 other vm's performing various functions. After a
>reboot of the server, all of these vms disappeared from the vm console. I
>crated "new" virtual machines using the vhd file of the orginals that were
>there. However, I have noticed that the sql server databases, mainly
>Sharepoint database, has no data that I have been putting in it for the last
>4 months. Where did this go? I thought all data resided on the vhd. I
>don't believe I had a snapshot of the sql server although there may have
>been one. If these are only used to return a machine to a previous point in
>time then this should not have mattered. Any insite would be greatly
>appreciated. I dread the though of having to recreate all of this work.
>One other note, the sql server had a second virtual disk where all of the
>databases reside.
>
>Thanks.
>
>
>BTW, there was not backup as the organization can't afford it at the moment
>and drive space is very limited. I know what you are going to say about
>that.
>

You should avoid having the host AV scan VHD and VMC files, they
should be excluded from the scan list.
Your VM's own AV software should protect itself.

--
Cheers,
Steve Jain, Virtual Machine MVP
http://vpc.essjae.com/
http://smudj.wordpress.com/

On Mon, 28 Dec 2009 08:57:48 -0500, "JackH"
<grandam010nospam@gmail.com> wrote:
>
>"Bo Berglund" <boberglund@myotherhome.sec> wrote in message
>newsqugj5126ri0s6vttji1eu9icjp7pg7u7t@4ax.com.. .
>> On Mon, 28 Dec 2009 02:41:25 -0500, "JackH"
>> <grandam010nospam@gmail.com> wrote:
>>
>>>BTW, there was not backup as the organization can't afford it at the
>>>moment
>>>and drive space is very limited. I know what you are going to say about
>>>that.
>>>
>> The cost of lost data is *way higher* than any disk you can buy to
>> store a backup on!
>> You can get 500 Gb of disk storage for next to nothing these days....
>>

>I know. Trying to convince the execs of that seems almost impossible.
>
>BTW, I did get everything back. That was close.
>
You could always buy a USB drive yourself and use it to back up your
important data just for peace of mind. A WD Passport drive is
incredibly cheap nowadays and you culd use it for something else too.

--

Bo Berglund (Sweden)