USE dbcenter
GO
ALTER DATABASE dbcenter SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE dbcenter SET RECOVERY SIMPLE
GO
USE dbcenter
GO
DBCC SHRINKFILE (N'dbcenter_Log' , 11, TRUNCATEONLY)
GO
USE dbcenter
GO
ALTER DATABASE dbcenter SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE dbcenter SET RECOVERY FULL
GO