Chapter 9 SQL Statements
591
RESTORE statement
Use this statement to restore a backed up database from an archive.
RESTORE DATABASE
filename
FROM
archive_root
[ CATALOG ONLY |
[ [ RENAME
dbspace_name
TO
new_dbspace_name
] …] ]
Must be connected to the utility database.
None.
"BACKUP statement" on page 401
"Backup and Data Recovery" on page 645 of the book ASA User’s Guide
Each RESTORE operation updates a history file called
backup.syb
, which is
a text file held in the same directory as your database server executable file.
The RENAME clause provides a way to change the restore location for each
dbspace. The dbspace name in a RENAME clause cannot be SYSTEM or
TRANSLOG.
RESTORE DATABASE replaces the database that is being restored. If you
need incremental backups, use the image format of the BACKUP command
and save only the transaction log; however, image backups to tape are not
supported.
Archive backups are only supported on Windows NT and Unix platforms.
CATALOG ONLY clause Retrieve information about the named archive,
and place it in the backup history file (
backup.syb
), but do not restore any
data from the archive.
RENAME clause Specifies a new location to restore each dbspace to.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
♦ Restore a database from a Windows NT tape drive:
RESTORE DATABASE ’d:\\dbhome\\cust.db’
FROM ’\\.\tape0’
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
Standards and
compatibility
Examples
To Next Page
Loading...