请大侠们指点如何处理这个问题.谢了。

lucowry

免费乐捐，感谢支持

由于操作错误，在对SYBASE数据库添加空间时，错选上了日志选项，导致数据存储设备DATA2变成了日志存储设备了，请问有什么办法更改回来吗？（如下图）
name                     db_size       owner                    dbid   created     status                                                                                                
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
JXC                         18600.0 MB sa                       4      Jun 26, 2004   select into/bulkcopy/pllsort, trunc log on chkpt, no chkpt on recovery                                
device_fragments               size          usage                created             free kbytes                   
------------------------------ ------------- -------------------- ------------------- ------------------------------
data1                          200.0 MB      data only            Jul 26 2004 10:27PM              434              
data1                          200.0 MB      data only            Nov  4 2004 10:31PM                0              
data1                          200.0 MB      data only            Sep 16 2004  8:41PM               70              
data1                          500.0 MB      data only            Aug 10 2004 10:20PM              126              
data1                          500.0 MB      data only            Dec 20 2004 12:42PM               14              
data1                          500.0 MB      data only            Jun 26 2004 11:43PM              168              
data1                          500.0 MB      data only            Nov 15 2004  9:51AM              196              
data1                          500.0 MB      data only            Sep 24 2004  8:40PM               56              
data1                          2000.0 MB     data only            Jan  4 2005 11:58AM               70              
data2                          300.0 MB      log only             Aug  5 2006  8:44AM not applicable                
data2                          500.0 MB      log only             Feb  1 2006  9:26AM not applicable                
data2                          1000.0 MB     log only             Feb  1 2006 10:11AM not applicable                
data2                          1000.0 MB     log only             Feb  5 2006 10:52PM not applicable                
data2                          1000.0 MB     log only             Sep 12 2005  3:20PM not applicable                
data2                          1700.0 MB     log only             Aug  5 2006  8:44AM not applicable                
data2                          2000.0 MB     log only             May 20 2005  9:50AM not applicable                
data2                          2000.0 MB     log only             Nov  4 2005  9:21AM not applicable                
data3                          3000.0 MB     data only            Feb  1 2006 10:59AM             1290              
log1                           500.0 MB      log only             Aug 17 2005  9:15AM not applicable                
log1                           500.0 MB      log only             Jun 26 2004 11:43PM not applicable                
                                                              
--------------------------------------------------------------
log only free kbytes = 897498                                 
device                         segment                                                                                                                                                                                                                                                        
------------------------------ ----------------------------------------------------------------------------------------------------------------------data1              default
data1              system
data2              logsegment
data3             default
data3             system
log1               logsegment

[此贴子已经被作者于2006-8-7 13:17:47编辑过]

aliking

如果里面还没有日志写进去，应该可以。

但这不是官方推荐的办法，可能会有隐患。

flybean

方法一:删除
方法二:把名字修改为logxxxx,呵呵

aliking

方法三： 先Dump Database，然后重建库，最后再Load Database

lucowry

谢谢各位大侠的指教，我想还是先用aliking的方法三先试试。

lucowry

我用以下方法把没用的日志空间释放出来，不知是否对，请指点。在线等，谢了。

use JXC
go
sp_dropsegment "logsegment",JXC,data2
use master
go
sp_configure "allow update",1
go
delete sysusages where dbid=4 and vstart in
(83886082,84039682,85063682,87930882)
go
sp_configure "allow update",0