Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: Load database behavior in ASE 12.5.3

    Hi All,
    I had a database attached to separate log and data devices.Space was not sufficient on this device, so i expanded the database to new device(data + log)
    my query looks like this:
    create database testDB on data1=10 log on log1=10 with override

    alter database testDB on test1=5 log on test1=5 with override.

    I had taken the dump of this database to local disk.

    Due to some sybase problem, i wanted to restore the database from the backup.Hence i deleted the existing database and device and create new device and database as follows:

    create database testDB on data1=10,test1=5 log on log1=10,test1=5 with override

    when i used the load database command to load the data from the backup, the data device got changed to log device.
    test1 device entirely became log device and log1 changed from log device to data device.The total allocated size is same the specified size, but the device allocation has changed.

    data1 is still data device
    log1 changed to data + log
    test1 entirely became log device

    Please someone tell me how to solve this problem.

    Thanks in advance

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    The sequence of data and log segments should match the original as in the dump. The load will allocate (override) the segments in the target db
    To allocate data on a data device and log on log device you can do
    create database testDB on
    for load

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts