- 论坛徽章:
- 0
|
我建立了设备:jcweb , jcweblog,
jcweb 用于放置data,
jcweblog 用于放置log,但是好像没有这么做阿!
请问我要实现这个怎么做阿?
我看到db的大小快不够了,就又
alter database jcweb on jcweb=128
1>; sp_helpdb jcweb
2>;go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
jcweb 1152.0 MB jcweb 4
Aug 28, 2003
trunc log on chkpt
(1 row affected)
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ------------------------------
jcweb 128.0 MB data and log
Feb 16 2004 5:30PM 130504
jcweb 256.0 MB data only
Aug 28 2003 6:20PM 392
jcweb 256.0 MB log only
Aug 28 2003 6:20PM not applicable
jcweblog 512.0 MB log only
Aug 28 2003 6:20PM not applicable
--------------------------------------------------------------
log only free kbytes = 782896
device
segment
------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
jcweb
default
jcweb
logsegment
jcweb
system
jcweblog
logsegment
(return status = 0) |
|