Shrink database data.
USE DatabaseName; GO -- Shrink the truncated file to 1024MB. DBCC SHRINKFILE (DataBaseFileName, 1024); GO
Shrink database log.
USE DatabaseName; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE DatabaseName SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (DatabaseFileLogName, 1); GO -- Reset the database recovery model. ALTER DATABASE DatabaseName SET RECOVERY FULL; GO
