Instance.Repair Method (String, String, String)

  • Статья

Repairs the metadata in system databases for the specified instance. Use this method if the instance is registered locally.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
Public Shared Sub Repair ( _
    instanceName As String, _
    databaseName As String, _
    schemaName As String _
)

public static void Repair (
    string instanceName,
    string databaseName,
    string schemaName
)

public:
static void Repair (
    String^ instanceName, 
    String^ databaseName, 
    String^ schemaName
)

public static void Repair (
    String instanceName, 
    String databaseName, 
    String schemaName
)

public static function Repair (
    instanceName : String, 
    databaseName : String, 
    schemaName : String
)

Параметры

  • instanceName
    The name of the instance of Notification Services for which the metadata information needs to be repaired.
  • databaseName
    The name of the instance database. This value is provided in the instance configuration when creating or updating the instance.
  • schemaName
    The name of the database schema for instance data. This value is provided in the instance configuration when creating or updating the instance.

Замечания

When you create an instance of Notification Services, information about the instance is recorded in the msdb database. A public view called msdb.NS90.NSInstances is provided over this table, which is used to discover instances on the server.

If you attach a database that contains instance or application data to a server, such as when you rebuild a server or move an instance of Notification Services, the metadata in msdb does not contain information about the instance. As a result, certain functions of Microsoft SQL Server Management Studio, the nscontrol command-prompt utility, and Notification Services Management Objects (NMO) may not work as expected.

This method attempts to obtain the server name of the Database Engine instance from the registry. If the instance is not registered locally, use the Repair(String,String,String,String) method overload.

For more information, see the Repair overload.

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

Instance Class
Instance Members
Microsoft.SqlServer.Management.Nmo Namespace

Другие ресурсы

Команда nscontrol repair