I am a newbie to Sybase, been doing MS SQL for a while
Made a mistake the other day. here it goes:
Server: Sybase ASE15
Devices-4(2 data and 2 log)(size 600 MB each)
Each db has 100 MB dATA assigned on each of the 2 data devices
Each db has 100 MB LOG assigned on each of the 2 LOG devices
/all devices are shared by all databases/
Made a mistake when expanding log device DEV_LG2, added 200 MB additional space
as DATA (executed the wrong script with OVERRIDE clause)for database DB4 instead of LOG. Now the device shows as "log and data device" instead of "log only"
database DB4 has select "into/bulk copy" checked, no logs are dumped, only truncate log at night, before full backup
All other databases are in full recovery mode
How can I fix this issue? or should I even worry about this?
If data already written I suggest you backup the db. Recreate db with data segments on data devices and log on log devices
e.g. create database db4 on dat2=100,lg2=100,dat2=100 for load
Make sure the sequence and size of the segments match as from sysusages order by dbid, lstart
Load the DB and drop the log segment from the accidental data segment.
If you don’t really need log backups then probably not too serious to leave as is depending on performance impact.