2010-05-11 01:20 PM
I have a VM which is running SQL Server 2005 and has the following disks:
C: 30GB VMDK datastore1
D: 500GB RDM "Virtual Mode" datastore2
E: 10GB VMDK datastore1
OS/program files is on C: and SQL databases, program files and DB dumps are located on drive D:
How does SMVI handle backing up Virtual Mode RDMs? I read that it doesn't work with physical mode but wasn't sure about virtual.
Should all of the disks be in the same ESX datastore? Otherwise I think this VM is going to get snapped twice and we could have to recover two different datastore/volumes for SFR.
P.S. SMSQL is not an option unfortunately.
Solved! SEE THE SOLUTION
2010-05-11 01:47 PM
It's a tad complex story.
First & foremost, if you want to do VSS-assisted application-consistent snapshots, then be wary of this:
"All application data needs to be contained on virtual disks (VMDKs) in NFS or VMFS datastores,
and not on RDMs or LUNs that are accessed using the Microsoft iSCSI Software Initiator in the
(plus have a look at the table on page 30)
Here is an interesting thread about using SMVI only vs. SMVI + SnapManager products:
2010-05-11 01:54 PM
Thanks for the reply.
Yeah, I checked out tr-3737 and the table on page 30 you refer to says "physical mode" RDMs. "Virtual Mode" RDMs (what I have) are a little different animal since VMware can take a snapshot of them -- and since that is the case, I figure why wouldn't it work with SMVI then? I searched tr-3737 for "virtual mode" and got 0 results..it seems to only reference physical mode.
What I'm aiming for here is "guest/file system level consistency"...not really application level. We are taking care of the SQL application backups via flat file dumps...so if I get the file system consistent, I've got what I need for this case.
2010-05-11 02:13 PM
I know that physical mode RDM is a must for SnapDrive / SnapManager environment (SD doesn't support virtual mode RDMs).
This isn't quite clear for me whether virtual mode RDM will actually cause any trouble for SMVI to work.
Personally I'd probably split SQL database from dumps into different drives - you can leave the former outside of SMVI, keep the latter as plain VMDK & back it up using SMVI.
2010-05-12 06:15 AM
Just for my knowledge and better understanding of the product/technology, why will virtual mode RDMs not work with SMVI? If VMware can take a snapshot of it, I thought SMVI would be ok then. The VM in question which has it does not have SDW installed.
Any plans to make virtual RDMs compatible in a future version? Sure would be nice