USE [master]
ALTER DATABASE RcBalance SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE RcBalance SET RECOVERY SIMPLE;
USE RcBalance
SELECT * from sys.database_files;
DBCC SHRINKFILE(N'Balance_Log' , 11, TRUNCATEONLY);
USE [master]
ALTER DATABASE RcBalance SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE RcBalance SET RECOVERY FULL;