Re: Cannot use file for clustered server

From: ebferro (ebferro_at_discussions.microsoft.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 05:39:11 -0800

Rod:
Many thanks for the help. My restore appears to be running nicely right now
so I think that fixed the problem.

"Rodney R. Fournier [MVP]" wrote:

> Move the G: Drive into the SQL Group (group 0 from you post).
> Stop the SQL clustered group.
> Double click SQL Server resource and add G: Drive as a dependency.
> Bring the SQL Group back online.
> Restore away :)
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
>
> "ebferro" <ebferro@discussions.microsoft.com> wrote in message
> news:24628F06-9C5C-4B4F-B7C6-50E82D24CF8F@microsoft.com...
> >I have a clustered server with a clustered instance of SQL Server 2000
> > running on it. I'm attempting to restore several databases to the
> > clustered
> > server from our production, non-clustered database server. I also want to
> > do
> > a move of log files at the same time. On the production server, the
> > database
> > and log files are on the same raid array. On the clustered server, I've
> > created two raid arrays, drive H: for the databases which is in cluster
> > group
> > 0 and drive g: for the logs which is in cluster group 1. The database
> > server
> > on the cluster is in group 0, by the way. I'm doing a restore using an
> > sql
> > file that works restoring databases and logs to a backup server on
> > different
> > drives so I'm reasonably sure that the restore syntax is correct. When I
> > attempt to do a restore of the log files on the cluster server, I receive
> > the
> > following error.
> > Msg 5184, Level 16, State 2, Line 1
> > Cannot use file g:\logs\ims.ldf for clustered server. Only formatted
> > files
> > on which the cluster resource of the server has a dependency can be used.
> > What does that mean? Does that mean that I have to put the log array in
> > the
> > same group as the clustered instance of sql server? If that's the case,
> > how
> > do I do that?
> > TIA
> > Ernie
>
>
>

Relevant Pages

  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering Question
    ... I have worked with Windows 2003 Small Business Server, Exchange Server 2003 and 2000 SQL server but not in a clustered environment. ... Do you want to cluster SQL? ... > you cannot install Cluster on a Small Business Edition, ...
    (microsoft.public.windows.server.clustering)
  • Re: Clustering Question
    ... The SQL Cluster would need to be ... SQL will need to Enterprise as well. ... So if I understand you correctly one computer will need Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to cluster instance from .NET
    ... I have tried using the SQL 2000 CD and i have ... Virtual IP addresses for the cluster resource groups. ... SQL Server will listen on only those IP addresses ... This is odd because the 172.16 network is a Class B ...
    (microsoft.public.sqlserver.clustering)