load DUMP mix data and log

[Mario Ascione]

Hi all,
I work with ASE Server 15.0.2 and I have a problem when I load a DUMP.

I have two physical devices, one for data (mydb_data.dat of 10Gb) and one
for log (mydb_log.dat of 6Gb). The database size is 4.5 Gb for data and 3.5
for log; I set a threshold that alter database on mydb_data.dat when data
grows. I made a DUMP when the database grew of 1G. After I reinstall the
database and try to load the dump.

I extend the database of 1G and I successfully load the dump. The problem
is that log and data are mixed on devices.

What can I do to avoid this?

Thanks

[Bret Halford]

Create the datase with the same order and size of segments as the original
database
(which is also the same as what you got after loading the database.

substitute your dbid into this script, run it, then substitute your appropriate
data and log device names for "DATA" and "LOG".

set nocount on
go
select
case
when lstart = 0 then "create "
else "alter "
end
+ "database " + db_name(dbid) + " on "
+ case
when segmap = 3 then " DATA "
when segmap = 4 then " LOG "
when segmap = 7 then " MIXED "
else " USERDEFINED "
end
+ " = " + str(size/512,10,1) as "--"
FROM sysusages
WHERE dbid = <dbid>
ORDER by dbid, lstart

Post by Mario Ascione
Hi all,
I work with ASE Server 15.0.2 and I have a problem when I load a DUMP.
I have two physical devices, one for data (mydb_data.dat of 10Gb) and one
for log (mydb_log.dat of 6Gb). The database size is 4.5 Gb for data and 3.5
for log; I set a threshold that alter database on mydb_data.dat when data
grows. I made a DUMP when the database grew of 1G. After I reinstall the
database and try to load the dump.
I extend the database of 1G and I successfully load the dump. The problem
is that log and data are mixed on devices.
What can I do to avoid this?
Thanks