create archive database

Creates an archive database.

Syntax

create archive database db_name
    [encrypt with key_name]
	[on db_device [= size]
		[, db_device [= size] ] ... ] 
	with scratch_database = db_name

Parameters

Examples

Usage

  • You can load dumps of the master database into an archive database.

  • You cannot use an in-menory database as an archive database.You should not use an in-memory database as a scratch database.

Permissions

There is no special permission to use the encrypt with option of the create archive database command. However, users need select permission on the database encryption key to be able to reference it as the key_name.

The permission checks for create archive database differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must have the create database privilege.

Disabled

With granular permissions disabled, you must be the system administrator or have create database privilege.