April 7, 2015 at 5:39 am
Hi! I have inherited a SQL Server environment of about 90 servers. I have several 2 node clusters where there was a designated drive for SQL Server backups. Also, some of these clusters have a FileServer resource that had a dependency on the backup disk resource. Now we want to remove those disks from the cluster. I have removed the dependency from the FileServer and I have taken the Backup disk offline and moved it to available storage. When you click on the Nodes the status of the SQL Server services is Partial Online. But when you click on the SQL Server service under the heading Services and applications, the status is Online. Also, the FileServer has a status of Offline. Is there somewhere that the FileServer resource is still referencing the Backup disk resource? Do I have to add another disk resource as a dependency to the FileServer? Is it safe to delete the backup disk resource? Thanks in advance for your help.
GF
April 7, 2015 at 7:49 am
The SQL server service resource itself usually has a dependency on any disks that are part of the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2015 at 8:59 am
Yes, I looked at the dependencies. Here is an example. There is a Backups disk that was part of the dependencies for the FileServer but I removed it as a dependency and then made it available storage and took it offline. So if that dependency has been removed why is the FileServer status offline and also the SQL Server service Partial Online.
FILESERVER DEPENDENCY REPORT
Cluster: FRLN1PCSQL05
Resource: FileServer-(FRLN1PVSQL08)(BACKUPS)
Started 07/04/2015 15:46:14
Completed 07/04/2015 15:46:14
'FileServer-(FRLN1PVSQL08)(BACKUPS)' dependencies are 'Name: FRLN1PVSQL08'.
'FileServer-(FRLN1PVSQL08)(BACKUPS)' required dependencies are Network Name, Storage.
'IP Address: 99.999.99.99' has no required dependencies.
'Name: FRLN1PVSQL08' dependencies are 'IP Address: 99.999.99.99'.
'SQL Network Name (FRLN1PVSQL08)' required dependencies are IP Address.
-------
SQL SERVER (ISQL01) DEPENDENCY REPORT
Cluster: FRLN1PCSQL05
Resource Group: SQL Server (ISQL01)
Started 07/04/2015 15:55:19
Completed 07/04/2015 15:55:19
'FileServer-(FRLN1PVSQL08)(BACKUPS)' dependencies are 'Name: FRLN1PVSQL08'.
'FileServer-(FRLN1PVSQL08)(BACKUPS)' required dependencies are Network Name, Storage.
'Group1_Data' has no required dependencies.
'Group1_Logs' has no required dependencies.
'Group2_Data' has no required dependencies.
'Group2_Logs' has no required dependencies.
'Group3_Data' has no required dependencies.
'Group3_Logs' has no required dependencies.
'Group4_Data' has no required dependencies.
'Group4_Logs' has no required dependencies.
'IP Address: 99.999.99.99' has no required dependencies.
'Name: FRLN1PVSQL08' dependencies are 'IP Address: 99.999.99.99'.
'SQL Network Name (FRLN1PVSQL08)' required dependencies are IP Address.
'SQL Server (ISQL01)' dependencies are 'Group4_Logs' and 'Group1_Data' and 'Group3_Logs' and 'Group2_Logs' and 'Group1_Logs' and 'Name: FRLN1PVSQL08' and 'Group2_Data' and 'Group4_Data' and 'Group3_Data' and 'SYSDB'.
'SQL Server (ISQL01)' has no required dependencies.
'SQL Server Agent (ISQL01)' dependencies are 'SQL Server (ISQL01)'.
'SQL Server Agent (ISQL01)' has no required dependencies.
'SYSDB' has no required dependencies.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply