Cannot use file for clustered server

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
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
|||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...
>
>