Recover a database when the only file you lost during media failure was the database file.
You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.
Make an extra backup copy of the current transaction log. Since the database file is unavailable, the transaction log contains the only record of the changes that have been made since the last backup.
Create a recovery directory to hold the files you use during recovery.
Copy the database file from the last full backup to the recovery directory.
Apply the transactions held in the backed up transaction logs to the recovery database. Use one of the following methods:
|Manually apply each transaction log in chronological order||
|Have the database server determine the correct order of the transaction logs and apply them automatically||
Perform validity checks on the recovery database.
Make a backup.
Move the database file to the production directory.
Notify users that they can access the production database.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|