Hierarchy

⤷

⤷

Basic Data
Data Element | MSSDEVNAME |
Short Description | MS SQL Server: Logical device name |
Data Type
Category of Dictionary Type | D | Domain |
Type of Object Referenced | No Information | |
Domain / Name of Reference Type | TEXT30 | |
Data Type | CHAR | Character String |
Length | 30 | |
Decimal Places | 0 | |
Output Length | 30 | |
Value Table |
Further Characteristics
Search Help: Name | ||
Search Help: Parameters | ||
Parameter ID | ||
Default Component name | ||
Change document | ||
No Input History | ||
Basic direction is set to LTR | ||
No BIDI Filtering |
Field Label
Length | Field Label | |
Short | 10 | devicename |
Medium | 15 | device name |
Long | 20 | logical device name |
Heading | 30 | logical device name |
Documentation
Definition
Logical name of an SQL Server device name. Device are the units on
disks used to store database information such as data or transaction
logs. Each logical device has a corresponding physical device, which is a file
on the file system. A device may hold only data, only logs, or both.
An entire device can be used by one database, or it
can be partitioned and used by several databases. The smallest unit of
device space which may be used is called the allocation unit and has
256 contiguous 2K pages.
The devices used for the SAP R/3 database must not be used by other
databases, and the data and transaction logs must reside on
different devices, which have associated files that reside on separate
physical disks (or separate RAID systems) for the best performance.
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |