You can mount the VHD as a drive using simple UI.
- Open Disk Management (from run you can use diskmgmt.msc)
- Select Attach VHD
- Alternatively you can also use the Diskpart to achieve the same
I need to check in a table, is the all day data available, here is the handy script to check the same.. DECLARE @startdate DATETIME ...