Create an archive database using the SAP Control Center
Administration Console.
Prerequisites
Consider these database attributes:
- Size:
-
sp_estspace helps you estimate table
and index space requirements based on the definition of a specific
table.
- Space for planned views, stored procedures, defaults,
rules, and triggers.
- Size of the transaction log.
- Space for anticipated expansion.
- Database device location, and whether there is enough space on that device.
- Transaction log location – SAP recommends that you store the transaction log on
a different device than the data.
Task- In the left pane of the Administration Console, expand .
- Click Archive Databases.
- Click the drop-down arrow and select New.
- On the Introduction screen, select the server in which to create a database.
- On the Database screen, enter the name of the database you want to create.
To enter the name of an archive database, you must first select a scratch database. You can mark a database as a scratch database by selecting the Scratch Database option from the database property sheet.
For information on scratch databases, see the System Administration Guide: Volume 2.
- (Optional) On the Devices screen, enter the size of the new database. If you do not enter a size, the default size allocated is 3MB. You can specify separately the amount of space to allocate to the log and data segments.
- (Optional) On the Options screen, if you created a
database encryption key, you can select Encrypt this database,
then specify the name of the database encryption key.
- (Optional) Click Summary to view your selected options.