Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

<MaxSize> Element (<LogFile>)

SQL Server 2000

Specifies the maximum size to which the SQL Server physical log file can grow.

Structure
<Database>
   ...
   <LogFile>
      ...
      <MaxSize>

Element Characteristics
Characteristic Description
Data Type string (see Remarks).
Default Value Unrestricted file growth.
Occurrence Optional once per <LogFile> node.
Updates Cannot be added, deleted, or modified.
Element Relationships
Relationship Elements
Parent Node <LogFile> Node
Remarks

The <MaxSize> value must be a non-negative integer indicating the file size, with an optional suffix to indicate the unit of measure: kilobyte (KB), megabyte (MB), gigabyte (GB), or terabyte (TB). If the suffix is not specified, the default unit of measure is megabytes (MB).

See Also
Defining a <LogFile> Node
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.