InstanceDatabaseLogFile Constructor (InstanceDatabaseOptions, String)

Initializes a new instance of the InstanceDatabaseLogFile class with a parent InstanceDatabaseOptions object and a name.

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

Синтаксис

'Декларация
Public Sub New ( _
    instanceDatabaseOptions As InstanceDatabaseOptions, _
    name As String _
)

public InstanceDatabaseLogFile (
    InstanceDatabaseOptions instanceDatabaseOptions,
    string name
)

public:
InstanceDatabaseLogFile (
    InstanceDatabaseOptions^ instanceDatabaseOptions, 
    String^ name
)

public InstanceDatabaseLogFile (
    InstanceDatabaseOptions instanceDatabaseOptions, 
    String name
)

public function InstanceDatabaseLogFile (
    instanceDatabaseOptions : InstanceDatabaseOptions, 
    name : String
)

Параметры

• instanceDatabaseOptions
  The InstanceDatabaseOptions object for the instance database.

• name
  A String, up to 128 characters in length, specifying the logical name of the log file.

  You cannot change the name. To alter an instance database after creating the instance, use the Microsoft SQL Server tools, such as SQL Server Management Studio.

Замечания

The logical name is used to refer to log file during any log management tasks. For more information, see the logical_file_name parameter in the CREATE DATABASE (Transact-SQL) topic.

Пример

The following examples show how to define a log file for an instance database:

InstanceDatabaseLogFile idb_log = 
    new InstanceDatabaseLogFile(idb, "MyInst_LogFile1");
idb_log.FileName = @"C:\NS\Full\MyInst_LogFile1.ldf";
idb_log.InitialSize = "3MB";
idb_log.MaxSize = "10MB";
idb_log.GrowthIncrement = "10%";
idb.InstanceDatabaseLogFiles.Add(idb_log);

Dim idb_log As InstanceDatabaseLogFile = _
    New InstanceDatabaseLogFile(idb, "MyInst_LogFile1")
idb_log.FileName = "C:\NS\Full\MyInst_LogFile1.ldf"
idb_log.InitialSize = "3MB"
idb_log.MaxSize = "10MB"
idb_log.GrowthIncrement = "10%"
idb.InstanceDatabaseLogFiles.Add(idb_log)

Платформы

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

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

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

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

См. также

Справочник

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

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

CREATE DATABASE (Transact-SQL)
Определение базы данных экземпляра
LogFile Element (ICF)