I am pretty new to sybase (note the user name) lol, and i have a database that has log showing up on a data device and vice versa, I would like to recreate the database and load back the data from the previous database with new devices but i need to have a clean separation of the log and data. Can anyone help me, thanks so much in advance.
shared_data 20.0 MB data only
shared_data 10.0 MB log only
shared_log 5.0 MB log only
shared_log 10.0 MB data only
You should have started a new thread for your problem.
Create the segments in the same sequence using the output from
select * from sysusages where dbid=db_id('dbname') order by lstart
Asuming it is the same order as what you listed, the below create db will fix it
create database dbname on
,shared_log=15 -- note you can sum if they follow each outher