Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Netapp: toasters

SMSQL help!!

 

 

Netapp toasters RSS feed   Index | Next | Previous | View Threaded


kwillia at smud

Dec 2, 2008, 12:42 PM

Post #1 of 2 (1085 views)
Permalink
SMSQL help!!

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 [at] smud
Phone: (916) 732-6744
Cell: (916) 240-4213


kwillia at smud

Dec 2, 2008, 2:41 PM

Post #2 of 2 (996 views)
Permalink
RE: SMSQL help!! [In reply to]

I just spent some time switching to the 32bit version, I received the
same results.

-----Original Message-----
From: Chaim Rieger [mailto:riegersteve [at] gmail]
Sent: Tuesday, December 02, 2008 1:13 PM
To: Ken Williams
Cc: toasters [at] mathworks
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 [at] smud
> Phone: (916) 732-6744
> Cell: (916) 240-4213
>


--
--
Chaim Rieger
www.jravel.com

Netapp toasters RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.