use databasename
go
alter database databasename set recovery simple
dbcc shrinkdatabase(databasename)
alter database databasename set recovery full
use databasename
go
alter database databasename set recovery simple
dbcc shrinkdatabase(databasename)
alter database databasename set recovery full