[sudarao]

Hi,
How do I identify if a database has mixed data and log segments.

Thanks

[trvishi]

sp_helpdb <dbname>

it will show data and log if its mixed

[moodleyn]

HI there

i'm running Sybase 11.9.2 and another systems administrator had installed my database with mixed log and data...so datadevice is data and log and so is log device.

I'm a bit new to DBA stuff, but what would be the easiest to do to sort the problem out? i don't want to crash anything because it is our live server for music.

THanks alot for any info given,

NIRI

[vubhaskar]

hi

to seperate the data and log

1) create a new device with
disk init name ="diskname" physname="path to device" , size="no"

2) Moving the log to newly created device

alter database <database name> log on "newly created device"

sp_logdevice databasename, devicename

this two steps will help you in moving your log to different device.

3) to confirm that run sp_helplog

[tahirkhalil]

Just a quick addition,

create a dummy table to move the log pointer to the new device:
create table dummy (col1 char(1))
go

insert into dummy values("a")

go 1000

dump tran <databasename> with truncate_only

To make sure we clear any log that might remain on the data device

use sp_helplog to make sure that the log starts on the new log device