Introducing CA ARCserve Backup Agents and Options › Using Agents › Agent for Sybase › Using the Agent for Sybase › Restore › How the Agent Restores Dropped Databases

How the Agent Restores Dropped Databases

A dropped database is a database that has been removed from the Sybase database and is no longer accessible. The agent can restore a dropped database, even if the database has not been recreated. To do this, the agent recreates the devices needed to restore the database by using information from the database backup session:

• The agent creates one or two devices large enough to hold all the backed up data. The agent creates these devices in the path set in the RestoreDir registry key.

  Note: The agent creates two devices if the dropped database had a separate log.

• If the key is Null, the agent creates the devices in the Sybase Adaptive Server home directory. The devices are named DbadvX.Dat or DbadvX.Log, where X is an increasing number.
• The agent recreates the database on these devices with the data definitions from the session being restored.

  Note: If the restore job fails, you must delete the DbadvX.Dat and DbadvX.Log devices using SQL commands in the Sybase isql utility.