有时候重建或迁移数据库,如果设备顺序和原来保持一致则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 lstartvstartDbName
DevTypeDevSize1 DevSize2
Free
------ ----------- ----------- ---------------------- ------------ -------------- ----------------- --------------
1 0 4 master
Data and log 6.00MB 3072Pages 1.63MB
130726660 master
Data and log50.00MB25600Pages49.77MB
2 04100 tempdb
Data and log 3.00MB 1536Pages 1.81MB
2153633554432 tempdb
Data and log2048.00MB1048576Pages2040.00MB
3 03076 model
Data and log 2.00MB 1024Pages 0.81MB
31513 05636 sybsystemdb
Data and log 2.00MB 1024Pages 0.76MB
31514 016777216 sybsystemprocs Data and log 256.00MB 131072Pages 198.69MB |