Classe LogFile

The LogFile object represents a SQL Server log file.

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.DatabaseFile
          Microsoft.SqlServer.Management.Smo.LogFile

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class LogFile _
    Inherits DatabaseFile _
    Implements ICreatable, ISfcSupportsDesignMode
'Utilizzo
Dim instance As LogFile

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class LogFile : DatabaseFile, 
    ICreatable, ISfcSupportsDesignMode

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class LogFile sealed : public DatabaseFile, 
    ICreatable, ISfcSupportsDesignMode

[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type LogFile =  
    class 
        inherit DatabaseFile 
        interface ICreatable 
        interface ISfcSupportsDesignMode 
    end

public final class LogFile extends DatabaseFile implements ICreatable, ISfcSupportsDesignMode

Nel tipo LogFile sono esposti i membri seguenti.

Costruttori

	Nome	Descrizione
	LogFile()	Initializes a new instance of the LogFile class.
	LogFile(Database, String)	Initializes a new instance of the LogFile class for the specified database and that has the specified name.
	LogFile(Database, String, String)	Initializes a new instance of the LogFile class for the specified database and that has the specified name and physical file name.

In alto

Proprietà

	Nome	Descrizione
	BytesReadFromDisk	Gets the number of bytes read from disk.
	BytesWrittenToDisk	Gets the number of bytes written to disk.
	FileName	Gets or sets the file name of the log file.
	Growth	Gets or sets the growth increment for the log file in KB or percent.
	GrowthType	Gets or sets the growth type for the data file in KB or percent.
	ID	Gets the ID value that uniquely identifies the log file.
	IsOffline	Gets the Boolean value that specifies whether the log file is offline or not.
	IsReadOnly	Gets the Boolean value that specifies whether the log file is read-only or can be updated.
	IsReadOnlyMedia	Gets the Boolean value that specifies whether the log file is stored on read-only media.
	IsSparse	Gets the Boolean value that specifies whether the file is a sparse file. Sparse files are used in database snapshots.
	MaxSize	Gets or set the maximum size to which the file can grow, in MB.
	Name	Gets or sets the name of the object. Ereditato da NamedSmoObject.
	NumberOfDiskReads	Gets an Int64 value that specifies the number of disk reads.
	NumberOfDiskWrites	Gets an Int64 value that specifies the number of disk writes.
	Parent	Gets or sets the Database object that is the parent of the LogFile object.
	Properties	Gets a collection of Property objects that represent the object properties. Ereditato da SqlSmoObject.
	Size	Gets or sets the current size of the log file, in KB.
	State	Gets the state of the referenced object. Ereditato da SmoObjectBase.
	Urn	Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. Ereditato da SqlSmoObject.
	UsedSpace	Gets the amount of used space in the log file in KB.
	UserData	Gets or sets user-defined data associated with the referenced object. Ereditato da SmoObjectBase.
	VolumeFreeSpace	Gets an Int64 value that specifies the volume free space in bytes.

In alto

Metodi

	Nome	Descrizione
	Alter	Updates any property changes to the object to the instance of Microsoft SQL Server. Ereditato da DatabaseFile.
	Create	Creates a log file on the instance of SQL Server as defined by the LogFile object.
	Discover	Discovers a list of type Object. Ereditato da SqlSmoObject.
	Drop	Drops a database file. Ereditato da DatabaseFile.
	Equals	Ereditato da Object.
	FormatSqlVariant	Formats an object as SqlVariant type. Ereditato da SqlSmoObject.
	GetContextDB	Gets the context database that is associated with this object. Ereditato da SqlSmoObject.
	GetDBName	Gets the database name that is associated with the object. Ereditato da SqlSmoObject.
	GetHashCode	Ereditato da Object.
	GetPropValue	Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject.
	GetPropValueOptional	Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject.
	GetPropValueOptionalAllowNull	Gets a property value of the SqlSmoObject object. Ereditato da SqlSmoObject.
	GetServerObject	Gets the server of the SqlSmoObject object. Ereditato da SqlSmoObject.
	GetType	Ereditato da Object.
	Initialize()	Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject.
	Initialize(Boolean)	Initializes the object and forces the properties be loaded. Ereditato da SqlSmoObject.
	IsObjectInitialized	Verifies whether the object has been initialized. Ereditato da SqlSmoObject.
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of SQL Server. Ereditato da SqlSmoObject.
	MarkForDrop	Marks the database file to be dropped next time its parent object is altered by the Alter method. Ereditato da DatabaseFile.
	Refresh	Refreshes the object and retrieves properties when the object is next accessed. Ereditato da SqlSmoObject.
	Rename	Renames a database file. Ereditato da DatabaseFile.
	SetParentImpl	Sets the parent of the SqlSmoObject to the newParent parameter. Ereditato da SqlSmoObject.
	Shrink	Shrinks a database file. Ereditato da DatabaseFile.
	ToString	Returns a String that represents the referenced object. Ereditato da SqlSmoObject.
	Validate	Validates the state of an object. Ereditato da SmoObjectBase.

In alto

Eventi

	Nome	Descrizione
	PropertyChanged	Represents the event that occurs when a property is changed. Ereditato da SqlSmoObject.
	PropertyMetadataChanged	Represents the event that occurs when property metadata changes. Ereditato da SqlSmoObject.

In alto

Implementazioni esplicite dell'interfaccia

	Nome	Descrizione
	IAlienObject.Discover	Discovers any dependencies. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject.
	IAlienObject.GetDomainRoot	Returns the root of the domain. Ereditato da SqlSmoObject.
	IAlienObject.GetParent	Gets the parent of this object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject.
	IAlienObject.GetPropertyType	Gets the type of the specified property. Ereditato da SqlSmoObject.
	IAlienObject.GetPropertyValue	Gets the value of the specified property. Ereditato da SqlSmoObject.
	IAlienObject.GetUrn	Gets the Unified Resource Name (URN) of the object. Non fare riferimento direttamente a questo membro nel codice. Supporta l'infrastruttura di SQL Server. Ereditato da SqlSmoObject.
	IAlienObject.Resolve	Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. Ereditato da SqlSmoObject.
	IAlienObject.SetObjectState	Sets the object state to the specified SfcObjectState value. Ereditato da SqlSmoObject.
	IAlienObject.SetPropertyValue	Sets the property value. Ereditato da SqlSmoObject.
	ISfcPropertyProvider.GetPropertySet	Gets the interface reference to the set of properties of this object. Ereditato da SqlSmoObject.
	ISfcSupportsDesignMode.IsDesignMode	Gets a Boolean value that specifies whether the object supports design mode.

In alto

Osservazioni

To get the LogFile object properties, users can be a member of the public fixed server role.

To set LogFile object properties, users must have ALTER permission on the database or be a member of the db_owner fixed database role.

To create or drop a log file, users must have ALTER permission on the database or be a member of the db_owner fixed database role.

Thread Safety

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Esempi

Utilizzo di filegroup e file per archiviare dati

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Utilizzo di filegroup e file per archiviare dati