Creating a database (dbinit utility)

Use the dbinit utility to create a database.

Prérequis

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.

Task

Run a dbinit command.

Résultat

A database is created.

Exemple

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

Creating a database (dbinit utility)

Task

See also