hi guys,a few questions regarding separating log and data device. currently i have a ase server 12.5.3 running with two databases the thing here is one of the physical device file were altered with data and log with separate databases. anyone encountered this kind of mistake of altering. sample below


how do you handle this kind of situation where 2 databases with one device file altered separately with data and log segment. Any possible problems encountered in the future with this kind of structure. your inputs will be much appreciated. Thanks

alter database DB1 on db1_data='1024M'
go
alter database DB2 log on db1_data='1024M'
go