use master ---select * from sysusages where dbid=db_id('test_shrink') 
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name = 'test_shrink') 	DROP DATABASE test_shrink
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdevices WHERE name = 'data1') exec sp_dropdevice data1
go
disk init  name  = 'data1',physname  = 'data1.dat',size  = '50M'
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdevices WHERE name = 'data2') exec sp_dropdevice data2
go
disk init  name  = 'data2',physname  = 'data2.dat',size  = '50M'
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdevices WHERE name = 'log1') exec sp_dropdevice log1
go
disk init  name  = 'log1',physname  = 'log1.dat',size  = '50M'
go

--------------------------
CREATE DATABASE test_shrink  ON data1 = '20M' log on  log1 = '10M' 
go
alter database test_shrink on data2='10m'
go
use 
test_shrink
go
exec sp_addsegment 'new_seg', 'test_shrink', 'data2'
go 
create table test_table (id int) on new_seg
go
exec sp_extendsegment 'new_seg', test_shrink, data1 
go
USE test_shrink
go
exec sp_dropsegment 'new_seg', test_shrink, data2 
go

use master
go
--alter database test_shrink off data2
go
dump database   test_shrink  to 'test_shrink.dmp' --with shrink_log
go
dump tran test_shrink  to 'test_shrink.tr.dmp'
go
load database test_shrink from 'test_shrink.dmp'
go
load tran test_shrink from 'test_shrink.tr.dmp'
go