SQL Skip Rules
|
Getting your Trinity Audio player ready...
|
 |
As vezes entender os problemas de uma instalação ou remoção pode ser complicado.
Existem cenários em que um Reboot naquele momento não é uma opção, ou um host está totalmente degradado e você precisa forçar a remoção de um SQL já migrado e em estado Offline.
Se você executar o Setup normalmente ele vai fazer uma série de checagens como: necessidade de reboot, acesso ao registro remoto, WMI, .NET, etc.
Dependendo do que você precisa, algumas opções podem ser desconsideradas na instalação/remoção, vou colocar o arquivo onde contém todas as explicações de todas as opções possíveis.
ATENÇÃO, esta informação não é documentada, caso precise usar, faça por conta e risco.
Para usar qualquer uma das opções ou mais de uma opção:
- SETUP /SkipRules=NoRebootPackage /Action=RemoveNode
Para ele não considerar mais de uma regra adicione um espaço entre elas.
- SETUP /SkipRules=NoRebootPackage WmiServiceStateCheck /Action=RemoveNode
Abaixo vou listar todas as regras do documento para facilitar a pesquisa, mas aqui tem o documento para download com a explicação de cada uma delas.
| Regra |
| ThreadHasAdminPrivilegeCheck |
| HasSecurityBackupAndDebugPrivilegesCheck |
| RebootRequiredCheck |
| WmiServiceStateCheck |
| AclPermissionsFacet |
| MediaPathLength |
| SetupCompatibilityCheck |
| NoRebootPackage |
| NoRebootPackageDownLevel |
| ServerCorePlatformCheck |
| ServerCore64BitCheck |
| ThreadHasAdminPrivilegeCheck |
| RebootRequiredCheck |
| WmiServiceStateCheck |
| AclPermissionsFacet |
| MediaPathLength |
| SetupCompatibilityCheck |
| NoRebootPackage |
| NoRebootPackageDownLevel |
| ServerCorePlatformCheck |
| ServerCore64BitCheck |
| Bids2008InstalledCheck |
| DenaliCTPbyCTPSxS |
| AclPermissionsFacet |
| FacetDomainControllerCheck |
| SSMS_IsInternetConnected |
| FacetWOW64PlatformCheck |
| FusionRebootCheck |
| Bids2008InstalledCheck |
| DenaliCTPbyCTPSxS |
| AclPermissionsFacet |
| FacetDomainControllerCheck |
| SSMS_IsInternetConnected |
| FacetWOW64PlatformCheck |
| IsFirewallEnabled |
| ServerCoreBlockUnsupportedSxSCheck |
| DEV10RTMDetected |
| ASSPIExistingFarmUnconfiguredWarningCheck |
| ASSPIInstanceNameNotInUseCheck |
| ASSPINewFarmConfiguredWarningCheck |
| ASSPIRequiresCompleteFarmCheck |
| ASSPIRequiresMossBitsCheck |
| ASSPIRequiresO14MossEnterpriseCheck |
| ASSPIRequiresO14MossSP1Check |
| SlipstreamMediaInfoCheck |
| PowerShellCheck |
| InternetConnectionToNETFX4DownloadSite |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| RS_IsDotNet3_5Installed |
| FAT32FileSystemCheck |
| InstanceClashRule |
| StandaloneInstall_HasClusteredOrPreparedInstanceCheck |
| BlockCrossLanguageInstall |
| BlockMixedArchitectureInstall |
| RS_DoesCatalogExist |
| RS_DoesCatalogTempDBExist |
| ASIsValidEditionForDeploymentModeCheck |
| FusionRebootCheck |
| Bids2008InstalledCheck |
| DenaliCTPtoCTPUpgrade |
| AclPermissionsFacet |
| FacetDomainControllerCheck |
| Cluster_IsOnlineIfClustered |
| SSMS_IsInternetConnected |
| FacetWOW64PlatformCheck |
| Cluster_DNS_Consistency_Rule |
| Cluster_IsWMIServiceOperational |
| ServerCoreBlockUnsupportedSxSCheck |
| YukonUpgradeSidRule |
| BlockCrossLanguageUpgrade |
| KatmiCTPupgradeToKilimanjaroBlockRule |
| KatmaiSlipstreamBuildToBuildUpgradeRule |
| RS_ValidDSN |
| RS_ValidDatabaseVersion |
| RS_ValidServerCollation |
| RS_NoCustomRenderingExtensions |
| RS_NoCustomSecurityExtensions |
| RS_NoCustomAuthExtensions |
| RS_ReportServerUnsupportedSecurityMode |
| RS_ReportManagerUnsupportedSecurityMode |
| RS_ReportServerClientCertificateRequired |
| RS_ReportManagerClientCertificateRequired |
| RS_RSServiceRunning |
| RSSHP_IsO12Installed |
| RSSHP_ReportServerVDirNotSupported |
| Engine_SqlServerServiceDisabled_Id |
| Engine_IsAweEnabledForX86 |
| Engine_IsMinusHEnabledForX86 |
| Engine_IsLPIMEnabledForX86 |
| Engine_IsLPIMEnabledForX64 |
| Engine_SqlEngineHealthCheck |
| Engine_AllSystemDatabasesAccessibleCheck |
| Engine_ResourceDLLUpdateRestartCheck |
| BlockMixedArchitectureUpgrade |
| Engine_ServiceAccountOnDomainCheck |
| Cluster_MultipleGroupsUpgradeRule |
| FeatureUpgradeMatrixCheck |
| IncompleteUpgradeCheck |
| FailedUpgradeCheck |
| LocalOnly_SqlFeatureStateCheck |
| LocalOnly_AsFeatureStateCheck |
| RsFeatureStateCheck |
| Cluster_FeatureDownGradeCheck |
| AS_IsServiceHealthy_Id |
| AS_UpgradeValidateMixedState |
| FAT32FileSystemCheck |
| DEV10RTMDetected |
| FacetWOW64ClusterUpgradeCheck |
| SlipstreamMediaInfoCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| RSSHP_UpgradePreDenali |
| PowerShellCheck |
| RS_IsDotNet3_5Installed |
| KatmaiRTMUpgradeBlockRule |
| KJRTMUpgradeBlockRule |
| YukonSP3UpgradeBlockRule |
| SideBySideUninstallRule |
| BlockMismatchedArchitectureUninstall |
| UninstallClusterBlockCheck |
| SlipstreamMediaInfoCheck |
| Cluster_IsOnlineIfClustered |
| FacetWOW64PlatformCheck |
| Cluster_IsWMIServiceOperational |
| ServerCoreBlockUnsupportedSxSCheck |
| AS_IsClusterServiceOffline |
| Engine_SqlResourceIsOfflineIfCurrentNodeActive |
| SlipstreamMediaInfoCheck |
| ServerCoreNetFxCheck |
| PowerShellCheck |
| RS_IsDotNet3_5Installed |
| FacetDomainControllerCheck |
| Engine_SqlServerServiceDisabled_Id |
| Engine_IsAweEnabledForX86 |
| Engine_IsMinusHEnabledForX86 |
| Engine_IsLPIMEnabledForX86 |
| Engine_IsLPIMEnabledForX64 |
| Engine_SqlEngineHealthCheck |
| Engine_OnlySupportedFeaturesUsedCheckSystem |
| Engine_OnlySupportedFeaturesUsedCheckUser |
| ServerCoreBlockUnsupportedSxSCheck |
| EditionUpgradeMatrixCheck |
| EditionDownGradeCheck |
| Cluster_EditionDownGradeCheck |
| BlockMixedArchitectureUpgrade |
| SlipstreamMediaInfoCheck |
| UcpEditionDowngradeRule |
| Engine_IsAlwaysOnFeatureEnabled |
| MultiSubnetClusterUpgradeCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| Engine_SqlServerServiceDisabled_RebuildDatabase |
| Engine_ResourceGroupIsActiveOnCurrentNode |
| Engine_SqlResourceIsOfflineIfCurrentNodeActive |
| FusionRebootCheck |
| Cluster_IsOnlineIfClustered |
| Cluster_IsWMIServiceOperational |
| Cluster_IsUserAdmin |
| Cluster_RemoteRegistryServiceFacet |
| Cluster_IsDomainController |
| SSMS_IsInternetConnected |
| IsDomainNetworkTopOfBindings |
| IsFirewallEnabled |
| Cluster_DNS_Consistency_Rule |
| FacetWOW64SetupCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| ClusterPrepare_HasClusteredInstanceCheck |
| ClusterSupportCheck |
| ClusterFeaturesCheckForBI |
| Engine_FilestreamRequiredHotfixesCheck |
| Engine_ResourceDLLUpdateRestartCheck |
| FAT32FileSystemCheck |
| InstanceClashRule |
| SlipstreamMediaInfoCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCorePlatformCheck |
| ServerCore64BitCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| DEV10RTMDetected |
| PowerShellCheck |
| RS_IsDotNet3_5Installed |
| FusionRebootCheck |
| Cluster_IsMachineClustered |
| Cluster_IsWMIServiceOperational |
| Cluster_IsUserAdmin |
| Cluster_IsOnline |
| Cluster_IsDTCInstalled |
| Cluster_IsDTCRunning |
| Cluster_IsDTCClustered |
| Cluster_VerifyForErrors |
| Cluster_VerifyForWarnings |
| Cluster_Prepped_Instance |
| Cluster_RemoteRegistryServiceFacet |
| Cluster_IsDomainController |
| Cluster_DNS_Consistency_Rule |
| FacetWOW64SetupCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| Cluster_NumberOfNodes |
| Cluster_FailedPreppedInstance |
| Cluster_ClusteredInstance |
| Cluster_IsDomainController |
| SqlFeatureStateCheck |
| AsFeatureStateCheck |
| IsSqlInstanceIdConsistentCheck |
| IsAsInstanceIdConsistentCheck |
| IsSqlVersionConsistentCheck |
| IsAsVersionConsistentCheck |
| IsSqlEditionConsistentCheck |
| IsAsEditionConsistentCheck |
| SlipstreamMediaInfoCheck |
| Cluster_SharedDiskFacet |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| Engine_FilestreamConfigurationCheck |
| MultiSubnetClusterOSCheck |
| MultiSubnetClusterSkuCheck |
| FusionRebootCheck |
| Cluster_IsMachineClustered |
| Cluster_IsWMIServiceOperational |
| Cluster_IsUserAdmin |
| Cluster_IsOnline |
| Cluster_IsDTCInstalled |
| Cluster_IsDTCRunning |
| Cluster_IsDTCClustered |
| Cluster_VerifyForErrors |
| Cluster_VerifyForWarnings |
| Cluster_RemoteRegistryServiceFacet |
| Cluster_IsDomainController |
| SSMS_IsInternetConnected |
| IsDomainNetworkTopOfBindings |
| IsFirewallEnabled |
| Cluster_DNS_Consistency_Rule |
| FacetWOW64SetupCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| ClusterSupportCheck |
| ClusterFeaturesCheckForBI |
| Cluster_SharedDiskFacet |
| PowerShellCheck |
| DEV10RTMDetected |
| SlipstreamMediaInfoCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| RS_IsDotNet3_5Installed |
| InstanceClashRule |
| FAT32FileSystemCheck |
| Engine_ResourceDLLUpdateRestartCheck |
| Engine_FilestreamRequiredHotfixesCheck |
| FusionRebootCheck |
| Cluster_IsMachineClustered |
| Cluster_IsWMIServiceOperational |
| Cluster_IsUserAdmin |
| Cluster_IsOnline |
| Cluster_IsDTCInstalled |
| Cluster_IsDTCRunning |
| Cluster_IsDTCClustered |
| Cluster_VerifyForErrors |
| Cluster_VerifyForWarnings |
| Cluster_RemoteRegistryServiceFacet |
| Cluster_IsDomainController |
| SSMS_IsInternetConnected |
| IsDomainNetworkTopOfBindings |
| IsFirewallEnabled |
| Cluster_DNS_Consistency_Rule |
| FacetWOW64SetupCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| Cluster_NumberOfNodes |
| SqlFeatureStateCheck |
| AsFeatureStateCheck |
| AddNodeEditionBlock |
| Engine_FilestreamRequiredHotfixesCheck |
| Engine_ResourceDLLUpdateRestartCheck |
| FAT32FileSystemCheck |
| InstanceClashRule |
| DEV10RTMDetected |
| SlipstreamMediaInfoCheck |
| MultiSubnetClusterOSCheck |
| MultiSubnetClusterSkuCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| PowerShellCheck |
| RS_IsDotNet3_5Installed |
| FusionRebootCheck |
| Cluster_IsMachineClustered |
| Cluster_IsWMIServiceOperational |
| Cluster_IsUserAdmin |
| Cluster_IsOnline |
| Cluster_RemoteRegistryServiceFacet |
| ServerCoreBlockUnsupportedSxSCheck |
| FusionRebootCheck |
| SysPrepFeatureCheck |
| Bids2008InstalledCheck |
| SSMS_IsInternetConnected |
| AclPermissionsFacet |
| FacetDomainControllerCheck |
| FacetWOW64PlatformCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| BlockMixedArchitectureInstall |
| BlockCrossLanguageInstall |
| FAT32FileSystemCheck |
| Unconfigured_SqlFeatureStateCheck |
| Unconfigured_AsFeatureStateCheck |
| Unconfigured_RsFeatureStateCheck |
| PowerShellCheck |
| SlipstreamMediaInfoCheck |
| InternetConnectionToNETFX4DownloadSite |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| ServerCorePlatformCheck |
| ServerCore64BitCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
| PowerShellCheck |
| RS_IsDotNet3_5Installed |
| SSMS_IsInternetConnected |
| IsFirewallEnabled |
| AclPermissionsFacet |
| FacetDomainControllerCheck |
| FacetWOW64PlatformCheck |
| ServerCoreBlockUnsupportedSxSCheck |
| EditionUpgradeMatrixCheck |
| EditionDownGradeCheck |
| FAT32FileSystemCheck |
| InstanceClashRule |
| ServerCoreBlockUnsupportedFeaturesCheck |
| ServerCoreNetFxCheck |
Filed under: SQL,SQLServerPedia syndication,Virtual PASS BR - @ 2017-03-05 9:43 pm