- 论坛徽章:
- 0
|
有时候重建或迁移数据库,如果设备顺序和原来保持一致则load后不会发生data和log的mix状态,但不知道原先设备分配顺序是什么样?
在准备工作时执行如下SQL就可以知道,顺序当然是按照(dbid, lstart)
-------------------------------BlueAeri--------------------------------------
select dbid, lstart, vstart, convert(varchar(22),db_name(dbid)) DbName,
(case segmap when 3 then 'Data only'
when 4 then 'Log only'
when 7 then 'Data and log'
when 2 then 'Default only'
when 1 then 'System only'
else '('+convert(varchar(3),segmap)+')Unknown' end) DevType,
str(size/512.0,12,2)+'MB' DevSize1,
str(size,12,0)+'Pages' DevSize2,
str(unreservedpgs/512.0,12,2)+'MB' Free
from master..sysusages
order by dbid, lstart
go
-------------------------------BlueAeri--------------------------------------
dbid lstart vstart DbName DevType DevSize1 DevSize2 Free
------ ----------- ----------- ---------------------- ------------ -------------- ----------------- --------------
1 0 4 master Data and log 6.00MB 3072Pages 1.63MB
1 3072 6660 master Data and log 50.00MB 25600Pages 49.77MB
2 0 4100 tempdb Data and log 3.00MB 1536Pages 1.81MB
2 1536 33554432 tempdb Data and log 2048.00MB 1048576Pages 2040.00MB
3 0 3076 model Data and log 2.00MB 1024Pages 0.81MB
31513 0 5636 sybsystemdb Data and log 2.00MB 1024Pages 0.76MB
31514 0 16777216 sybsystemprocs Data and log 256.00MB 131072Pages 198.69MB
[ 本帖最后由 BlueAeri 于 2007-12-27 18:02 编辑 ] |
|