I want to be able to backup a database and restore it on another server but seem unable to get this to work. Having browsed various mailing lists it would appear the way to do this is by using the DBMCLI program to run the following scripts:
# Create the database dbmcli -n servername db_create IVT DMO,password # Run the script to initialise the database dbmcli -d IVT -u DMO,password -i inst01.cli # INST01.CLI Script to create a new database # param_startsession param_init param_put MAXUSERTASKS 50 param_checkall param_commitsession param_addvolume 1 LOG LOG_001 F 2000 param_addvolume 1 DATA DAT_001 F 10000 db_admin util_connect util_execute INIT CONFIG util_activate DBA,dagivs util_release load_systab -u DBA,dagivs -ud dagivs # End of Script # Run the script to load the database dbmcli -d IVT -u DMO,password -i inst02.cli # INST02.CLI Script to reload the database from a backup db_cold util_connect DMO,dagivs medium_put IVTBKP 'C:\Backups\IVTBKP' FILE DATA recover_start IVTBKP DATA util_release # Set the database online dbmcli -d IVT -u DMO,password db_online The database fails to start - apparently because the log version is different to the database, I saw some posting indicating it might be possible to delete the logs to fix this problem. Any help would be appreciated. Duncan Groenewald _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
