I've been working with support for several days now on this issue and we are all stumped.
Quick background on the environment: -Clustered FAS3070 -Fiber channel LUNs - OnTap 7.2.5.1 -Windows Server 2003 R2 64bit clustered configuration -MS SQL 2005 -1 LUN per filer volume, using mount point vs drive letters for the mounts. -SMSQL 2.1.1 (previously) and 2.1.2 (currently)
This clustered environment is for Sharepoint and also has SMMOSS member agents.
This problem has existed since configuration.
We're in the process of migrating data to a new SQL cluster and we're coming across a issue with the DBCC verification.
Collecting verification information... Getting database backup information from SnapInfo file... Initializing SnapManager server on remote machine [SNPSPDB01]... Mounting Snapshot [sqlsnap__prdspdb01_12-02-2008_12.21.38] for Virtual Disk F:\shpntprod_db\ of Computer PRDSPDB01 This Snapshot is mounted as the drive [Z:]. Mount Snapshot succeeded. Mounting Snapshot [sqlsnap__prdspdb01_12-02-2008_12.21.38] for Virtual Disk F:\shpntprod_log\ of Computer PRDSPDB01 This Snapshot is mounted as the drive [Y:]. Mount Snapshot succeeded. Cannot find the data file in the mounted drive: f:\shpntprod_db\PRD_Hydro_Content_01.mdf Dismounting Virtual Disk Z of SnapShot [sqlsnap__prdspdb01_12-02-2008_12.21.38]... Dismount Snapshot succeeded. Dismounting Virtual Disk Y of SnapShot [sqlsnap__prdspdb01_12-02-2008_12.21.38]... Dismount Snapshot succeeded. Unable to locate the database data file on the mounted disk drive.
Database verification information was not updated. There is an error during database verification.
Any ideas why the verification would fail? It looks to me like its trying to find a data file mounted on the f:\ drive instead of the Y:\ or Z:\ drive.. Could this be some type of SQL permission issue? I'm at a total loss.
Here is the kicker: When I installed SMSQL5.0 the problem went away, but SMMOSS (Snapmanager for Share point) doesn't work with SMSQL5.0, it requires 2.1.1/.2.1.2
__________________________________________________________ Ken Williams Storage Administrator, Business Technology Operations Sacramento Municipal Utility District E-Mail: kwillia@smud.org Phone: (916) 732-6744 Cell: (916) 240-4213