Very Computer

sp_logdevice dbname, device_name
go

This will place all future allocations of syslogs on the new device.

If you have the drive space, create two databases on the same server and use
statements like:
   insert destinationdb.owner.tablename
    select * from sourcedb.owner.tablename

to move the data sans bcp.

-Mike S.

Is there any way in which to separate the data and log segments so that
they physically utilize separate devices.  I did take one database, made a
dump of it,  dropped the database, recreated the databae so that the data
segment and log segment were configured on separate devices, and reloaded
the database from the dump.  To no avail.  The log segment is on the
device supposedly only created for data.

Any suggestions would be greatly appreciated.  What I'm trying to avoid is
having to bcp out all the tables, recreate the database appropriately, and
bcp back in the tables.  --- a very time-consuming process.

     or

    or

Thanks in advance!

disk init......

alter database your_db on new_device

sp_logdevice new_device

: We are currently using Sybase v10 on HP Unix 9.0.5.  Several of our
: database have been created with data and log configured on the same
: device.  As a result, our transaction logs have been constantly filling
: up, requiring "dump tran <database_name> with no_log.  Our transaction
: logs are not required for recovery.  

: Is there any way in which to separate the data and log segments so that
: they physically utilize separate devices.  I did take one database, made a
: dump of it,  dropped the database, recreated the databae so that the data
: segment and log segment were configured on separate devices, and reloaded
: the database from the dump.  To no avail.  The log segment is on the
: device supposedly only created for data.

: Any suggestions would be greatly appreciated.  What I'm trying to avoid is
: having to bcp out all the tables, recreate the database appropriately, and
: bcp back in the tables.  --- a very time-consuming process.

:                                                                          
:      or
:                                                                  

:                                                                          
:     or
:                                                                  

: Thanks in advance!

--

Regards,
Kelvin