Blog Pages

SAP ASE (sybase) - Create Database

A device has to be created.
How to create a device:
https://copypastenet.blogspot.com/2019/12/sap-ase-sybase-create-device.html


-- Create Database
create database DATABASENAME
    on DEVICENAME='100M'      -- data device
    log on LOGDEVICENAME='100M' -- log device, if not declared - log will be in the same device as the data
GO

For more options in the creation:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1600/doc/html/san1393050910896.html

No comments:

Post a Comment