Very Computer

Hi.

I created a small db with data and logging on the same device.  I now want
to modify this so that logging is on a seperate device.  I re-created the
db and loaded from tape but the same device fragments are created with log
segments on the default device (even though I created the db with
'log on Mydev=4')

I followed the procedure in the Admin book, using sp_logdevice, dump trans,
sp_helplog etc but this had no effect.  All logging still goes to the
default device.

Sybase 10.0.2.   Any suggestions ??      thanks

Andrew Mackay
Newfoundland Hydro

|> Hi.
|>
|> I created a small db with data and logging on the same device.  I now want
|> to modify this so that logging is on a seperate device.  I re-created the
|> db and loaded from tape but the same device fragments are created with log
|> segments on the default device (even though I created the db with
|> 'log on Mydev=4')
|>
|> I followed the procedure in the Admin book, using sp_logdevice, dump trans,
|> sp_helplog etc but this had no effect.  All logging still goes to the
|> default device.
|>
|> Sybase 10.0.2.   Any suggestions ??      thanks

System 10+ does alter segements on load to match the image of the
database being loaded.  You should be able to drop the log segment
using various stored procedures.  You can also do it by directly
updating sysusages.segmap (be careful!).  Change the "7" for that
device fragment to a "3", then run dbcc dbrepair(dbname, remap).

--
---------------------------------------------------------------------

| Sybase Technical Support         fax (510)-922-3911         __|  
| 6475 Christie Avenue                                       |__  
| Emeryville, CA 94608 USA         exec sp_realitycheck()       |___
|                                                                   |
#####################################################################

Much safer than playing with system tables I think ;-}

Joe

--

------------ Joe Fernley ------------

Tel: 0956 271890

: Hi.

: I created a small db with data and logging on the same device.  I now want
: to modify this so that logging is on a seperate device.  I re-created the
: db and loaded from tape but the same device fragments are created with log
: segments on the default device (even though I created the db with
: 'log on Mydev=4')

: I followed the procedure in the Admin book, using sp_logdevice, dump trans,
: sp_helplog etc but this had no effect.  All logging still goes to the
: default device.

: Sybase 10.0.2.   Any suggestions ??      thanks

: Andrew Mackay
: Newfoundland Hydro

Just to make sure, you did sp_dropsegmeng logsegment, 'device'

JB

Quote:

>Just to make sure, you did sp_dropsegmeng logsegment, 'device'

Andrew