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
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