- 論壇徽章:
- 0
|
有時候重建或遷移數(shù)據(jù)庫,如果設(shè)備順序和原來保持一致則load后不會發(fā)生data和log的mix狀態(tài),但不知道原先設(shè)備分配順序是什么樣?
在準(zhǔn)備工作時執(zhí)行如下SQL就可以知道,順序當(dāng)然是按照(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 編輯 ] |
|