Using the with override Option with create database

The with overide option allows machines with limited space to maintain their logs on device fragments that are separate from their data.

SAP does not recommend this practice, but it may be the only option available on machines with limited storage, especially if you must get databases back online following a hard-disk failure.

You can still dump your transaction log, but if you experience a media failure, you cannot access the current log, since it is on the same device as the data. You can recover only to the last transaction log dump; all transactions between that point and the failure time are lost.

In this example, the log and data are on separate fragments of the same logical device:

create database littledb
    on diskdev1 = "4M"
    log on diskdev1 = "1M"
    with override

The minimum database size you can create is the size of model.