USE [cm] GO ALTER DATABASE [cm] SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (2,2); GO ALTER DATABASE [cm] SET RECOVERY FULL; GO DBCC SHRINKDATABASE('cm'); GO BACKUP DATABASE [cm] TO DISK = 'C:/Share/CM.bak'
RESTORE DATABASE cm FROM DISK='C:/CM.bak'
USE [cm] GO ALTER DATABASE [cm] SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (2,2); GO ALTER DATABASE [cm] SET RECOVERY FULL; GO DBCC SHRINKDATABASE('cm'); GO BACKUP DATABASE [cm] TO DISK = 'C:/Share/CM.bak'
RESTORE DATABASE cm FROM DISK='C:/CM.bak'