dbTalk Databases Forums  

Msg 5184 when creating database

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Msg 5184 when creating database in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Folke
 
Posts: n/a

Default Msg 5184 when creating database - 12-05-2003 , 09:19 AM






When trying to create a database on a cluster node with
drives D: Data and F: Log the following error occurs.

Server: Msg 5184, Level 16, State 2, Line 2
Cannot use file 'F:\StressDb1_Log.LDF' for clustered
server. Only formatted files on which the cluster resource
of the server has a dependency can be used.

I'm not sure what "the cluster resource of the server"
is???
Anyone who has a clue??




Reply With Quote
  #2  
Old   
Allan Hirt
 
Posts: n/a

Default Msg 5184 when creating database - 12-05-2003 , 09:51 AM






Sounds like you're trying to place the files on a local
disk. On a clustered instance of SQL Server, all files
for a DB must reside on the shared disk array. That drive
is a dependency of the SQL Server resource, and resides in
the group with the SQL Server resources.
Quote:
-----Original Message-----
When trying to create a database on a cluster node with
drives D: Data and F: Log the following error occurs.

Server: Msg 5184, Level 16, State 2, Line 2
Cannot use file 'F:\StressDb1_Log.LDF' for clustered
server. Only formatted files on which the cluster
resource
of the server has a dependency can be used.

I'm not sure what "the cluster resource of the server"
is???
Anyone who has a clue??



.


Reply With Quote
  #3  
Old   
Rand Boyd [MS]
 
Posts: n/a

Default RE: Msg 5184 when creating database - 12-05-2003 , 11:42 AM



Any drive that a clustered instance of SQL Server uses must be in the same
resource group as teh SQL Server and SQL Server must have a dependency on
it. You can check these using Cluster Administrator.

Rand
This posting is provided "as is" with no warranties and confers no rights.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.