dump database dbname using config

[Former Member]

Hi,

By using sp_config_dump stored procedure have taken backup of database:

sp_config_dump @config_name='sampleDB',

@stripe_dir = '/sybase/backup' ,

@compression = '101' ,

@verify = 'header'

Have dump the database using following syntax: dump database sample using config = 'sampleDB'

Now what is the syntax for loading database as following syntax is Incorrect:

1)load database from "dump_path" with compression

OR

2)load database from "compress::dump_path"

[victoria_normand · Accepted solution]

Hi,
I guess you are running SAP application on ASE (this is the comunity for SAP applications running on ASE), therefore the 'enable dump history' parameter is set by default, so you might find the answer about which would be the correct load command to execute using the "listonly='LOAD_SQL' " option on your load database command. This is specified on SAP Note "1611715 - SYB: How to restore an SAP ASE database server (Windows) " or SAP Note "1618817 - SYB: How to restore an SAP ASE database server (UNIX) ":

On the "Load user databases" part (existent on both notes), you have this item:

>>>>
2. Load the database and transaction logs.
Log in to ASE with isql as user 'sapsa' and execute the command:

1> load database <DB_NAME> with listonly = 'LOAD_SQL'
2> go

Save the output to an SQL command file and execute it in isql.
<<<<

Regards,
Victoria.

[Former Member · Accepted solution]

Hi Maria,

Thanks for the reply. Using this syntax it has executed

LOAD DATABASE sam FROM '/backup/sam.DB.20150205.113523.000'

successfully.

But while dumping I have mentioned compression level=101. So while loading database will it take take same compression level or without any compression?? Bcoz I have tried the given solution for sample database of 1GB but in production db sizes are of 500gb so will take more time or will compress??

[victoria_normand · Accepted solution]

Hi Nikhil,

As mentioned Mark the compression option is valid only for the dump to reduce space requirements. In particular the compression level 101 (recommended for SAP Applications on ASE, see SAP Note 1588316 - SYB: Configure automatic database and log backups
) is used to provide a faster and better compression of the dump and it is not require any specific syntax for the load database.

Best regards,
Victoria.