HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Application Integration
cancel
Showing results for 
Search instead for 
Did you mean: 

MPIO log in SQL server everytime a snapshot is made

 
SOLVED
Go to solution
jliu79
Frequent Advisor

MPIO log in SQL server everytime a snapshot is made

I keep seeing these events every time a snapshot is made on Nimble for the SQL server:

Events ID 1:

\Device\MPIODisk### created.

And once in a while it will give me some warnings and errors like this:

A Single Path Fail-Over is being attempted on \Device\MPIODisk###

Microsoft DSM failed to return a Path to \Device\MPIODisk###

The device, \Device\Harddisk#\DR###, is not ready for access yet.

The SQL server is a Windows 2008 R2 VM on a Windows 2012 cluster. The version of the SQL server is SQL 2008 R2.

Everything seems to be working fine for the SQL server, but I just want to know what those events and warnings and errors are about. Thanks.

4 REPLIES
aherbert23
Trusted Contributor

Re: MPIO log in SQL server everytime a snapshot is made

This is part of the synchronization process with VSS. When a snapshot is taken it is mounted to the server temporarily and VSS validates the snapshot. Once it is complete it's removed. That's why you're seeing a new device appear and then be disconnected. 

jliu79
Frequent Advisor

Re: MPIO log in SQL server everytime a snapshot is made

Thanks Adam. Any idea what would cause those error messages?

aherbert23
Trusted Contributor
Solution

Re: MPIO log in SQL server everytime a snapshot is made

Those will happen sometimes when the snapshot is disconnected from the host. It's a normal and expected occurrence.

jliu79
Frequent Advisor

Re: MPIO log in SQL server everytime a snapshot is made

Ok, thanks again Adam.