sp_refit_admin

(Cluster environments only) Provides an interface to perform various disk refit-related actions, such as showing the current status of the disk refit process, resetting the state of the disk refit process, skipping the disk refit process for an instance, and so on.

Syntax

sp_refit_admin [‘help’] | 'status' | ['reset’ | 'skiperfit' [, instance_name]]
	|[ 'removedevice’, device_name]

Parameters

Examples

Usage

There are additional considerations when using sp_refit_admin:
  • You must follow the instructions in Troubleshooting in the Clusters Users Guide after executing skiprefit, to ensure the consistency of the system tables before resuming normal operation.

  • Use removedevice only during the disk refit process, to remove the device from the refit process. Do not use it in place of sp_dropdevice

  • You can use sp_refit_admin even when the instance is started with the -m option and trace flag 3608 ON.

For information on problems encountered with disk refit, see the Troubleshooting and Error Guide

Permissions

The permission checks for sp_refit_admin differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage disk privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.