LUN failing to mount during DBCC check

[haas]

Smsql 5.0.0.385

Snapdrive 6.0.2.2416

NetApp Release 7.2.6.1:

SQL Server 9.0.3042 (2005)

I am getting an error when verifying my snapshot.  The DBCC gets through 6 databases, then tries mounting the seventh snapshot as a temporal LUN.  

All databases are in the same volume.  The first 6 databases are in separate LUNs for recovery reasons.  The next 5 databases, which fail, share a LUN and drive letter.

I attached the entire log, but cut out a snippet that shows the successful unmounting of the previous drive, and the failure to mount the new drive.

--------------------------------------------------------------------------------------

[11:06:43.012]  Detaching database [vivclabrtp02__Mount].

[11:06:43.544]  Database was detached successfully.

[11:06:43.544]  Dismounting LUN Z of SnapShot [sqlsnap__vidbrtp01_09-08-2009_10.40.38__daily]...

[11:07:03.872]  Dismount Snapshot succeeded.

[11:07:03.950]  Database verification information updated.

[11:07:03.950]  Collecting verification information...

[11:07:03.950]  Getting database backup information from SnapInfo file...

[11:07:04.981]  Running verification from local server....

[11:07:05.028]  Mounting Snapshot [sqlsnap__vidbrtp01_09-08-2009_10.40.38__daily] for LUN u of Computer vidbrtp01

[11:07:05.044]  SnapManager will mount the snapshot sqlsnap__vidbrtp01_09-08-2009_10.40.38__daily using available drive letter; otherwise, it will use directory C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint if no drive letter is available

[11:10:38.527]  WARNING: Unable to get default mount point directory

[11:10:38.527]  Snapshot will be mounted on subdirectory [MPDisk001]

[11:10:47.933]  [SnapDrive Error]: You are trying to create a volume mount point on a temporal LUN.

This configuration is not recommended and as a result is not supported by SnapDrive.

(SnapDrive Error Code: 0xc0040410)

[11:10:48.042]  [SnapDrive Error]: You are trying to create a volume mount point on a temporal LUN.

This configuration is not recommended and as a result is not supported by SnapDrive.

[11:10:48.042]  Database verification information was not updated.

[11:10:48.058]  There is an error during database verification.

[sourav]

Hi John,

Please check the following KB article: -

https://now.netapp.com/Knowledgebase/solutionarea.asp?id=kb51582

Looks like the same error.

Regards,

Sourav Chakraborty.

[haas]

Thank you for your input.  Unfortunately, I don't think this is the solution.  The article you pointed me to is using vmware.  I am not using vmware.

It is interresting that the DBCC fails to mount LUNs almost every night, but the LUN it fails on is random.  There are a few nights where the LUN mount does not fail at all, and it works.

[sourav · Accepted solution]

This looks more like a connectivity issue or an issue with the HUK. I would suggest that you open a case with NetApp Support.

Regards,

Sourav.