LogFile Members
The LogFile object represents a Microsoft SQL Server log file.
The following tables list the members exposed by the LogFile type.
Public Constructors
| 名稱 | Description | |
|---|---|---|
| LogFile | Overloaded. Initializes a new instance of the LogFile class. |
頂端
Protected Fields
| 名稱 | Description | |
|---|---|---|
.gif "ms219749.protfield(zh-tw,SQL.90).gif") |
m_ExtendedProperties | (inherited from SqlSmoObject ) |
頂端
Public Properties
(see also Protected Properties )
| 名稱 | Description | |
|---|---|---|
.gif "ms219749.pubproperty(zh-tw,SQL.90).gif") |
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. (inherited from NamedSmoObject) |
|
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. (inherited from SqlSmoObject) |
|
Size | Gets or sets the current size of the log file, in KB. |
|
State | Gets the state of the referenced object. (inherited from SmoObjectBase) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from 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. (inherited from SmoObjectBase) |
頂端
Protected Properties
| 名稱 | Description | |
|---|---|---|
.gif "ms219749.protproperty(zh-tw,SQL.90).gif") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject) |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject) |
|
PresetProperties | Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject) |
|
ScalarResult | Gets the scalar result for the referenced object. (inherited from SqlSmoObject) |
頂端
Public Methods
(see also Protected Methods )
| 名稱 | Description | |
|---|---|---|
.gif "ms219749.pubmethod(zh-tw,SQL.90).gif") |
Alter | Updates any property changes to the object to the instance of Microsoft SQL Server. (inherited from DatabaseFile) |
|
Create | Creates a log file on the instance of Microsoft SQL Server as defined by the LogFile object. |
|
Drop | Drops a database file. (inherited from DatabaseFile) |
|
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
Initialize | Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject) |
|
MarkForDrop | (inherited from DatabaseFile ) |
.gif "ms219749.static(zh-tw,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (inherited from SqlSmoObject) |
|
Rename | (inherited from DatabaseFile ) |
|
Shrink | (inherited from DatabaseFile ) |
|
ToString | Returns a String that represents the referenced object. (inherited from SqlSmoObject) |
頂端
Protected Methods
| 名稱 | Description | |
|---|---|---|
.gif "ms219749.protmethod(zh-tw,SQL.90).gif") |
AlterImpl | (inherited from SqlSmoObject ) |
|
AlterImplFinish | (inherited from SqlSmoObject ) |
|
AlterImplInit | (inherited from SqlSmoObject ) |
|
AlterImplWorker | (inherited from SqlSmoObject ) |
|
BindDefaultImpl | (inherited from SqlSmoObject ) |
|
BindRuleImpl | (inherited from SqlSmoObject ) |
|
CheckCollation | (inherited from SqlSmoObject ) |
|
CheckObjectState | Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject) |
|
CheckObjectStateImpl | (inherited from SqlSmoObject ) |
|
CheckVersion80 | Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject) |
|
CheckVersion80SP3 | Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject) |
|
CheckVersion90 | Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject) |
|
CheckVersionBelow90 | (inherited from SqlSmoObject ) |
|
CleanObject | (inherited from SqlSmoObject ) |
|
CreateImpl | (inherited from SqlSmoObject ) |
|
CreateImplFinish | (inherited from SqlSmoObject ) |
|
CreateImplInit | (inherited from SqlSmoObject ) |
|
DropImpl | (inherited from SqlSmoObject ) |
|
DropImplWorker | (inherited from SqlSmoObject ) |
|
Finalize | (inherited from Object ) |
|
FormatSqlVariant | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceScript | (inherited from SqlSmoObject ) |
|
GetBindDefaultScript | (inherited from SqlSmoObject ) |
|
GetBindRuleScript | (inherited from SqlSmoObject ) |
|
GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetDateTimeParameter | (inherited from SqlSmoObject ) |
|
GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) |
|
GetDBName | Gets the database name associated with the object. (inherited from SqlSmoObject) |
|
GetEnumParameter | (inherited from SqlSmoObject ) |
|
GetFragOptionString | (inherited from SqlSmoObject ) |
|
GetGuidParameter | (inherited from SqlSmoObject ) |
|
GetParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetPropValue | (inherited from SqlSmoObject ) |
|
GetPropValueOptional | (inherited from SqlSmoObject ) |
|
GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) |
|
GetRealValue | (inherited from SqlSmoObject ) |
|
GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) |
|
GetServerName | Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetSqlServerVersionName | Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetStringParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) |
|
GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) |
|
ImplInitialize | (inherited from SqlSmoObject ) |
|
IsCollectionDirty | (inherited from SqlSmoObject ) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of Microsoft SQL Server. (inherited from SqlSmoObject) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (inherited from SqlSmoObject) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject) |
|
IsVersion80SP3 | (inherited from SqlSmoObject ) |
|
MarkDropped | (inherited from SqlSmoObject ) |
|
MarkForDropImpl | (inherited from SqlSmoObject ) |
|
MemberwiseClone | (inherited from Object ) |
|
PostAlter | (inherited from SqlSmoObject ) |
|
PostCreate | (inherited from SqlSmoObject ) |
|
PostDrop | (inherited from SqlSmoObject ) |
|
RenameImpl | (inherited from NamedSmoObject ) |
|
RenameImplWorker | (inherited from NamedSmoObject ) |
|
ScriptAlter | (inherited from DatabaseFile ) |
|
ScriptChangeOwner | (inherited from NamedSmoObject ) |
|
ScriptCreate | This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code. (inherited from SqlSmoObject) |
|
ScriptDdl | (inherited from SqlSmoObject ) |
|
ScriptDrop | (inherited from DatabaseFile ) |
|
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) |
|
ScriptImplWorker | (inherited from SqlSmoObject ) |
|
ScriptRename | (inherited from DatabaseFile ) |
|
SetParentImpl | (inherited from SqlSmoObject ) |
|
Trace | (inherited from SqlSmoObject ) |
|
UnbindDefaultImpl | (inherited from SqlSmoObject ) |
|
UnbindRuleImpl | (inherited from SqlSmoObject ) |
|
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
頂端
請參閱
參考
LogFile Class
Microsoft.SqlServer.Management.Smo Namespace
其他資源
Using Filegroups and Files to Store Data
CREATE DATABASE (Transact-SQL)