| Author |
Topic |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2008-04-05 : 14:11:20
|
| 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 yes will the error go . Does changes in cluster resource need server restart . |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-05 : 14:49:22
|
| Did you create dependency for Log files properly? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-05 : 14:50:40
|
| Here it is:http://technet.microsoft.com/en-us/library/ms177447.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 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
80 Posts |
Posted - 2008-04-07 : 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
80 Posts |
Posted - 2008-04-08 : 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 settings at ur end . If u wnat me change the dependency , if i bring the resource offline , change the dependency and bring it online, is there anything else also required to be done (like rebooting ..) . |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 15:39:32
|
| We use mount points as well. You just need to add G: as a dependency.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2008-04-25 : 04:24:13
|
quote:
Originally posted by tkizer
We use mount points as well. You just need to add G: as a dependency.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
Tara ,I check http://support.microsoft.com/kb/819546/ which contains following info .The SQL Server 2005 resource depends on the SQL network name resource and the physical disk resources that hold its data. When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over.Is this true . Have u faced any db corruption for actual failover. Is there any potential problem / pitfall for following this advice . |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-25 : 13:08:28
|
| We've had this 4-node cluster with 11 SQL instances in production for about 2 years now. Each instance is using 3-4 mount points. We've failed over to other nodes dozens and dozens of times. We've never had any database corruption whatsoever. We check DBCC CHECKDB every night. Perhaps it makes a difference which software package you are using for the mount points. I'm not sure though. We are using Veritas Volume Manager on a Hitachi SAN. I will be checking with my team though if they know anything about this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2008-04-25 : 23:54:48
|
| That's fine . If u get any info from ur tip , please let me know. In the meanwhile I believe there is noharm in adding all mount points . In fact in that there is no need for root hard disk dependency (as the mount points already depend on the same and SQL resource depends on mount) . Any comments / experience are welcome. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2008-04-28 : 00:52:15
|
| On adding mount points to SQL resource all my errors in the error logs on resource failover (OS error 21 writing log files ) vanished. I thought these errors were due to disk signature difference , old controller firmware etc . And worked in those directions . I didnt new that the solution lied in this small step .Nevertheless , at the end of the day I learnt lot . |
|
|
|
|
error 5184 when adding sqllogs in separate disk