Very Computer

I have a database which ran out of space (sybsecurity in this case). The
database did not have a seperate log device. To create extra space I added a
new log device to the database. How can I make it log only to this new
device and not to the original device anymore? Currently it logs to both
(see sp_helpdb output below):

I hope somebody can help, thanks!

1> sp_helpdb sybsecurity
2> go
 name                     db_size       owner                    dbid
         created
         status

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

----------------------------------------------------------------------------
--------------------------
 sybsecurity                   300.0 MB sa                           11
         Oct 22, 1998
         trunc log on chkpt

 device_fragments               size          usage                free
kbytes
 ------------------------------ ------------- --------------------
-----------
 sybsecuritydev                 100.0 MB      data and log
0
 sybsecuritylogdev              200.0 MB      log only
204784

(return status = 0)

Quote:> I have a database which ran out of space (sybsecurity in this case). The
> database did not have a seperate log device. To create extra space I added a
> new log device to the database. How can I make it log only to this new
> device and not to the original device anymore? Currently it logs to both
> (see sp_helpdb output below):

> I hope somebody can help, thanks!

sp_dropsegment
sp_logdevice
sp_placeobject

You should be able to get one, or more, of these to work for you.

--
Mark A. Parsons