Create database for Load ok mais online ko
Voici mon problème :
J'ai un serveur de production en ASE 11.5 (@@version = Adaptive Server Enterprise/11.5/P/NT/OS 4.00/1/fbu/Wed Sep 10 03:56:32 PDT 1997).
Ce serveur ce fait vieux et va être remplacé par un serveur tout beau, tout neuf sur lequel y'a ASE 15.0.1 (@@version = Adaptive Server Enterprise/15.0.1/EBF 14206 ESD#2/P/NT (IX86)/Windows 2000/ase1501/2400/32-bit/OPT/Fri Jan 12 17:47:14 2007).
Le truc, c'est de récupérer les bases de données du serveur en 11.5 pour les mettres sur celui en 15.0.1. Pour ça, j'ai mes sauvegardes quotidiennes (dump).
Aujourd'hui, j'essaye cette manip sur mon serveur de test aussi en 15.0.1.
- J'ai commencé par créer mes databases devices à l'identique,
- puis de créer ma base en mode "For Load"
- et j'execute la ligne de commande
Code:
load database mabase from "mondump"
et là j'ai ce message :
Citation:
Server Message: Number 3216, Severity 10
Server 'MALTE', Line 1:
Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 602801, Severity 1
Server 'MALTE_BS', Procedure 'bs_read_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'cosmeto0719712751' section number 1 mounted on disk file 'C:\dump_cosmeto_database'
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 1540 kilobytes (1%) LOADED.
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 36360 kilobytes (23%) LOADED.
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 79880 kilobytes (52%) LOADED.
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 122380 kilobytes (79%) LOADED.
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_perform_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 153612 kilobytes (100%) LOADED.
Server Message: Number 418801, Severity 1
Server 'MALTE_BS', Procedure 'bs_end_load', Line 0:
Backup Server: 4.188.1.1: Database cosmeto: 153620 kilobytes (100%) LOADED.
Server Message: Number 304201, Severity 1
Server 'MALTE_BS', Procedure 'bs_end_load', Line 0:
Backup Server: 3.42.1.1: LOAD is complete (database cosmeto).
Server Message: Number 12584, Severity 16
Server 'MALTE', Line 1:
Unsupported log version 3, from ASE version '11.5', found for database 'cosmeto' Upgrade from an ASE version earlier than '11.9' is unsupported. Database cannot be opened.
On lit bien
Citation:
Load is complete
Mais la suite me laisse dans le flou :bug:
J'ai bien trouver une commande, mais que je ne sais pas utiliser :
Code:
Alter database upgrade
Please help :cry:
Merci.
