Home Forums SQL Server 2008 SQL Server 2008 High Availability Remove resource from 2 node cluster RE: Remove resource from 2 node cluster

  • April 7, 2015 at 8:59 am

    #1789218

    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.