I just spent some time switching to the 32bit version, I received the same results.
-----Original Message----- From: Chaim Rieger [mailto:riegersteve@gmail.com] Sent: Tuesday, December 02, 2008 1:13 PM To: Ken Williams Cc: toasters@mathworks.com Subject: Re: SMSQL help!!
-SMSQL 2.1.1 (previously) and 2.1.2 (currently)
you have to install the 32 bit version of SM (if my recollection serves right) we ran into this issue as well
Ken Williams wrote:
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