Sybase Load Syntax

Load command is used to restore database from a backup into an existing database. The load command replaces everything in a database with the contents of the dump, and it destroys all data that was residing in the database prior to the load.

Sybase Load Syntax:

load database database_name cumulative from [compress::[compression_level::]]stripe_device [at backup_server_name] [density = density_value, blocksize = number_bytes, dumpvolume = volume_name, file = file_name] with verify only [= header | full | crc] [stripe on stripe_device [at backup_server_name] [density = density_value, blocksize = number_bytes, dumpvolume = volume_name, file = file_name] [[stripe on stripe_device [at backup_server_name] [density = density_value, blocksize = number_bytes, dumpvolume = volume_name, file = file_name]]...] [with { listonly=load_sql | create_sql, density = density_value, blocksize = number_bytes, dumpvolume = volume_name, file = file_name, [dismount | nodismount], [nounload | unload], passwd = password, until_time = datetime, notify = {client | operator_console}, [override]}]]

Example:

Please go through Database Refresh in Sybase

Powered by k2schools