Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types » Database creation


Creating a database (dbinit utility)

Use the dbinit utility to create a database.


There are no prerequisites for this task.

Contexte et remarques

With this utility, you can include command line options to specify different settings for the database.

A transaction log mirror provides extra protection for critical data and enables complete data recovery if a media failure on the transaction log occurs. To maintain a transaction log mirror when you create a database, specify the -m option.

  • Run a dbinit command.


A database is created.


For example, to create a database called company.db with a 4 KB page size, run the following command:

dbinit -dba DBA,sql -p 4k company.db

The following command (which should be entered on one line) initializes a database named company.db, with a transaction log kept on a different device and a mirror on a third device.

dbinit -dba DBA,sql -t d:\log-dir\company.log -m
e:\mirr-dir\company.mlg c:\db-dir\company.db

 See also