Re: Restore db in cluster environment

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 29 Jun 2007 11:02:14 -0400

Your T: drive have not been made a dependency of SQL Server. You need to do
the following:

1) Make the SQL Server resource offline.
2) Move the T: drive resource into the SQL group if it is not already
there.
3) Bring up the properties of the SQL Server resource.
4) Make the T: drive a dependency of SQL Server.
5) Bring the SQL group online.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:eybFs1luHHA.4916@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I got this error when I move the log file to a diff location in the cluster
environment.
Any ideas and solution?

Thanks

Msg 5184, Level 16, State 2, Line 1
Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only
formatted files on which the cluster resource of the server has a dependency
can be used.

.

Follow-Ups:
- Re: Restore db in cluster environment
  - From: mecn

References:
- Restore db in cluster environment
  - From: mecn

Prev by Date: Restore db in cluster environment
Next by Date: Re: Restore db in cluster environment
Previous by thread: Restore db in cluster environment
Next by thread: Re: Restore db in cluster environment
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL 2005 Clustering issues - tempdb and BUILTINAdministrators
... The dependency is the other way around i.e ... You should check the dependencies of the SQL Server resource and make sure ... add an explicit login for the cluster service account. ...
(microsoft.public.sqlserver.clustering)
Re: Log Shipping share on cluster
... dependency of the SQL Server resource. ... SQL Server won't even see the drive letter. ... local disk should NEVER be used, because if you lose node in the cluster you ...
(microsoft.public.sqlserver.replication)
Re: SQL 2005 Clustering issues - tempdb and BUILTINAdministrators
... You should check the dependencies of the SQL Server resource and make sure ... formatted files on which the cluster resource of the server has a ... dependency can be used. ...
(microsoft.public.sqlserver.clustering)
Re: Passive node starting the SQL Server services - services set to ma
... Manual start for services is correct for a cluster. ... Look at the applicaiotn logs on both ... The SQL Server services are set to manual on both nodes. ... IE (SQL Server resource group has NODE1/NODE2; ...
(microsoft.public.sqlserver.clustering)
Re: Cannot restore databae successfully
... On your new cluster, you have not made drive E: a dependency for SQL Server. ... Restore your DB ...
(microsoft.public.sqlserver.clustering)