- 论坛徽章:
- 0
|
I want to release 4MB space in TestDev under scope of logsegment.
What can I do after I performed "sp_dropsegment logsegment, jimdb, TestDev" ?
1>; sp_helpsegment logsegment
2>; go
segment name status
------- ------------------------------ ------
2 logsegment 0
device size
------------------------------ ----------------------
TestDev 4.0MB
jimld0 8.0MB
free_pages
-----------
6119
table_name index_name indid
------------------------------ ------------------------------ ------
syslogs syslogs 0
total_size total_pages free_pages used_pages
---------------------- ----------- ----------- -----------
12.0MB 6144 6119 25
(return status = 0)
1>; |
|