quote:

---

Originally posted by rmiao

Did you expand db and log after expanding devices?

---

use master

go
set nocount on
declare @mess	varchar(200)
select @mess = 'Server ' + @@SERVERNAME + ' at ' + 
	convert(varchar(50), getdate(),111) +' ' +convert(varchar(50), getdate(),114)
print ' '
print @mess
print ' '
print	'Display Database Segment Sizes'
print ' '
go
set nocount off
go

select
	--a.dbid,
	DB_Name = a.name,
	--b.segmap,
	Segment_Type =
		convert(varchar(15),
		case b.segmap
		when 3 then 'Data'
		when 4 then 'Log'
		when 7 then 'Data and Log'
		else 'Unknown'
		end),
	--Segment_Size = b.size,
	Seg_Megabytes = (b.size * 2) / (1024) ,
	--b.Lstart ,
	--DB_Creation_Date = a.crdate,
	--Current_Date_Time = getdate(),
	Device_Name = c.Name,
	Device_Path = c.phyname
	--,b.Vstart,
	--c.Low,
	--c.High
from
	master.dbo.sysdatabases a,
	master.dbo.sysusages b,
	master.dbo.sysdevices c
where
	a.dbid = b.dbid		and
	b.vstart >= c.low	and
	b.vstart <= c.High	and
	c.high > 19		and
	c.phyname <> 'nul'
order by
	a.dbid, b.lstart


go
print ' '
print	'Display Database Devices'
print ' '
go
set nocount on
go

select
	DeviceNumber =
		case
		when name = 'master'
		then 0
		when convert(int,convert(binary(1), (low / 0x01000000))) = 0
		then convert(smallint,null)
		else convert(smallint,convert(int,convert(binary(1), (low / 0x01000000))))
		end,
	*
into
	#t1
from
	master..sysdevices

go
set nocount off
go

select
	DeviceNumber ,
	low ,
	high ,
	name ,
	phyname
	--*
	--status ,
	--cntrltype ,
	--mirrorname ,
	--stripeset
from
	#t1
where
	DeviceNumber is not null
order by
	DeviceNumber,
	Name


go
drop table #t1
go
print ' '
print	'End'
print ' '