You can minimize downtime when rebuilding a database by using the backup and log translation utilities.
It is recommended that you make backup copies of your database files before rebuilding a database.
Verify that no other scheduled backups can rename the transaction log. If the log is renamed, the transactions from the renamed transaction logs must be applied to the rebuilt database in the correct order.
You must have the BACKUP DATABASE system privilege.
Using dbbackup -r, create a backup of the database and log, and rename the transaction log.
Rebuild the backed up database on another computer.
Perform another dbbackup -r on the production server to rename the transaction log.
Run the dbtran utility on the transaction log and apply the transactions to the rebuilt database.
Shut down the production server and copy the database and transaction log.
Copy the rebuilt database onto the production server.
Run dbtran on the transaction log from Step 5.
Start the rebuilt database on a personal server (dbeng16), to ensure that users cannot connect.
Apply the transactions from Step 8.
Shut down the database server and start the database on a network server (dbsrv16), to allow users to connect.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|