Define Physical Files for a Database in SQL Server 2008
Use the SQL Server Database Physical File Editor to define a physical file that contains all the attributes needed for a database in a SQL Server 2008 physical model.
To define SQL Server physical files for a database
The SQL Server Database Editor opens.
The SQL Server Database Physical File Editor opens.
Note: Click New on the toolbar to create a new physical file. Use the Enter filter text box to filter a very large list of physical files to quickly locate the one that you want to define.
Displays the physical file name. You can change the physical file name in this field.
Displays how the physical file is used.
Note: This field cannot be changed in this editor.
Specifies the database state. Make a selection from the drop-down list.
Displays the location of the physical file.
Specifies the initial size of the physical file. Enter a numerical value using a whole number (no decimals). You can use the suffixes KB (kilobyte), MB (megabyte), GB (gigabyte), and TB (terabyte).
Default: MB
Specifies how large the physical file can grow. Enter a numerical value using a whole number (no decimals). You can use the suffixes KB (kilobyte), MB (megabyte), GB (gigabyte), and TB (terabyte).
Default: MB
Specifies how to grow the physical file. Make a selection from the drop-down list.
Note: The selection you make in this field determines how you enter a value in the File Growth field.
Specifies the amount of space to add to the physical file each time it needs to grow.
Default: MB
Limits: Use a numerical value with one of the following suffixes: KB (kilobyte), MB (megabyte), GB (gigabyte), or TB (terabyte) if you selected Value for the File Growth By option. Use a numerical value without a suffix if you selected Percent for the File Growth By option. A value of zero indicates that there is no automatic growth.
Determines the read/write status of the physical file. Make a selection from the drop-down list.
Specifies whether the physical file is on read-only media when you select the check box.
Specifies whether the physical file is a sparse file when you select the check box.
The physical file is defined and the SQL Server Database Physical File Editor closes.
The SQL Server Database Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|