- 论坛徽章:
- 0
|
sybase 11.9,在sybase central 里查看database 属性时误点了move log 按钮,结果造成
default 减少,logsegment 增大,哪位高手知道如何解决?以下是sp_helpdb DATABASEA的结果:
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
DATABASEA 109810.0 MB sa 6 Apr 25, 2004 select into/bulkcopy/pllsort, trunc log on chkpt
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
BAKDAT1 3070.0 MB log only 3143680
BAKDAT2 3050.0 MB log only 1400784
BAKLOG1 1150.0 MB log only 1171552
BAKLOG2 2550.0 MB log only 2611200
DATA1 50.0 MB log only 0
DATA1 500.0 MB log only 512000
DATA1 500.0 MB log only 512000
DATA1 550.0 MB log only 3648
DATA1 1000.0 MB log only 3936
DATA1 1000.0 MB log only 22560
DATA1 1000.0 MB log only 27728
DATA1 1500.0 MB log only 416
DATA1 2850.0 MB log only 2048
DATA2 1000.0 MB data only 208
DATA2 3800.0 MB data only 4096
DATA2 5000.0 MB data only 1792
DATA3 100.0 MB data only 32
DATA3 200.0 MB data only 144
DATA3 200.0 MB data only 192
DATA3 500.0 MB data only 224
DATA3 601.0 MB data only 9232
DATA3 2000.0 MB data only 688
DATA3 2000.0 MB data only 9984
DATA3 2000.0 MB data only 22720
DATA3 2399.0 MB data only 1920
DATA4 200.0 MB data only 96
DATA4 800.0 MB data only 208
DATA4 1000.0 MB data only 240
DATA4 1000.0 MB data only 336
DATA4 1000.0 MB data only 368
DATA4 1000.0 MB data only 2320
DATA4 5000.0 MB data only 12672
DATA5 500.0 MB data only 10624
DATA5 1000.0 MB data only 1280
DATA5 1000.0 MB data only 16736
DATA5 2000.0 MB data only 288
DATA5 2000.0 MB data only 5040
DATA5 3500.0 MB data only 1456
DATA6 500.0 MB data only 32
DATA6 500.0 MB data only 176
DATA6 500.0 MB data only 240
DATA6 500.0 MB data only 368
DATA6 500.0 MB data only 368
DATA6 500.0 MB data only 720
DATA6 1000.0 MB data only 304
DATA6 1000.0 MB data only 720
DATA6 1000.0 MB data only 1088
DATA6 1000.0 MB data only 1376
DATA6 1000.0 MB data only 2048
DATA6 1000.0 MB data only 2384
DATA6 1000.0 MB data only 45616
DATA7 1000.0 MB data only 48
DATA7 1000.0 MB data only 64
DATA7 1000.0 MB data only 80
DATA7 1000.0 MB data only 160
DATA7 1100.0 MB data only 6752
DATA8 1000.0 MB data only 80
DATA8 1000.0 MB data only 18848
DATA8 3100.0 MB data only 16704
DATA9 200.0 MB data only 0
DATA9 200.0 MB data only 0
DATA9 9600.0 MB data only 118208
LOG1 500.0 MB data only 736
LOG1 500.0 MB data only 752
LOG1 1000.0 MB data only 944
LOG1 1000.0 MB data only 1216
LOG1 1000.0 MB data only 1680
LOG1 1000.0 MB data only 1952
LOG1 1000.0 MB data only 5920
LOG1 1000.0 MB data only 39872
LOG1 2000.0 MB data only 29856
LOG2 500.0 MB log only 2784
LOG2 1000.0 MB log only 1392
LOG2 1000.0 MB log only 2096
LOG2 1000.0 MB log only 4512
LOG2 1000.0 MB log only 8000
LOG2 1000.0 MB log only 196944
LOG2 1000.0 MB log only 234368
LOG2 1000.0 MB log only 433728
LOG2 1000.0 MB log only 586944
LOG2 1500.0 MB log only 128
LOG3 1000.0 MB log only 1024000
LOG3 1040.0 MB log only 1064848
device segment
------------------------------ ------------------------------------------------------------------------------------------
BAKDAT1 logsegment
BAKDAT2 logsegment
BAKLOG1 logsegment
BAKLOG2 logsegment
DATA1 logsegment
DATA2 default
DATA2 system
DATA3 default
DATA3 system
DATA4 default
DATA4 system
DATA5 default
DATA5 system
DATA6 default
DATA6 system
DATA7 default
DATA7 system
DATA8 default
DATA8 system
DATA9 default
DATA9 system
LOG1 default
LOG1 system
LOG2 logsegment
LOG3 logsegment |
|
免费注册
发表于 2007-12-06 22:29
发表于 2007-12-07 00:06
