Mssql Error 5184
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » cannot use file for clustered server sql 2012 SQL Server 2005 » SQL Server 2005 General Discussion » Error:5184
Either The Disk Resource Containing The File Is Not Present In The Cluster Group
When creating db specyfying... Error:5184 When creating db specyfying another loations for log file Rate Topic Display Mode sql server cluster dependencies Topic Options Author Message j mangualj mangual Posted Tuesday, October 16, 2007 11:05 AM Valued Member Group: General Forum Members Last Login: Thursday, October 22, 2015 1:15 PM Points: cannot use file for clustered server sql 2014 57, Visits: 393 SQL Server 2005 SP2 on a cluster node with two members. OS is Windows 2003 Server SP2. This the production environment. Test environment is not clustered. On the Cluster Administrator/Groups there are 2 groups defined for instances. Need to create db on an instance which has a group with 3 physical drives, U, V and W.
Msg 5184, Level 16, State 2
When trying to create a new database the default location for data and log files uses the U drive by default. If I overwrite the file location to use the V drive for the log file to separate data and log file locations, the following error is displayed : " Cannot use file 'V:\..\..' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the SQL server does not have a dependency on it. Create Database Failed. Some files names listed could not be created. Check related errors.(Microsoft SQL Server, Error: 5184)"The disk dive V is past of the group for that instance so do I need to create dependencies among the physical disks for this particular group? Any suggestions Post #411395 Tommy BollhoferTommy Bollhofer Posted Tuesday, October 16, 2007 2:06 PM Ten Centuries Group: General Forum Members Last Login: Thursday, August 18, 2016 5:39 AM
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlservercentral.com/Forums/Topic411395-149-1.aspx Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/295732 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100371 new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums High Availability (2005) error 5184 when adding sqllogs in separate disk Reply to Topic Printer Friendly Author Topic Hitesh Shah Yak Posting Veteran India 80 Posts Posted-04/05/2008: 14:11:20 cannot use I am trying to create logs in a separate disk in the cluster. I get error 5184 indicating some dependency error . Here is the dependency layout in SQL server group.f:\ --> Mount pointf:\appdata --> data for SQL and user database data files --> F:f:\appothers--> other datafiles --> f:G:\--> mount pointg:\sqllogs --> user data base logfiles --> g:Does this mean I have to make f:\appdata dependent on g:\sqllogs also. If cannot use file yes will the error go . Does changes in cluster resource need server restart . sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-04/05/2008: 14:49:22 Did you create dependency for Log files properly? sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-04/05/2008: 14:50:40 Here it is:http://technet.microsoft.com/en-us/library/ms177447.aspx rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-04/05/2008: 21:42:07 Have to add g:\ as dependency resource to sql resource, need stop sql resource to do that. Hitesh Shah Yak Posting Veteran India 80 Posts Posted-04/07/2008: 03:09:47 Did work successfully by adding g:\ as dependency resource to sql resource. Thanks all for the help. Hitesh Shah Yak Posting Veteran India 80 Posts Posted-04/08/2008: 14:02:24 The error 5184 is solved . But I have one question out of curiosity .I have g:\ and g:\sqllogs (mounted on g:\) separate disks configured. g:\sqllogs is dependent on g:\ . For adding disk dependency for SQL server resource , what should I add resource dependency g:\ or g:\sqllogs . I have added g:\ and it works . But I feel it should be dependent on g:\sqllogs (which is in turn already dependent on g:\) . Please tell me the actual setting