INF: Altering Database to Add Multiple Log Devices

ID Number: Q60055

1.10 1.11 4.20

OS/2

Summary:

When a database and log were originally created on the same device and

the database is altered to add a device to assign a log to it, the log

is physically moved to this new device, so that the log and the

database are no longer competing with each other for disk space.

If additional devices are added for logs, SQL Server logically

accesses the accumulated log devices as if they were one large log;

the logs do not need to be in contiguous memory.

Additional reference words: 1.10 1.11 4.20 performance and tuning,

dump and load