Shrink Query For SQL 2008 R2 (Single Database Shrink Query)

Shrink Query For SQL 2008 R2 (Single Database Shrink Query)

USE eMO
GO
ALTER DATABASE eMO SET RECOVERY simple
GO
DBCC SHRINKFILE (eMO_log , 1)
Go
ALTER DATABASE eMO SET RECOVERY Full

Note: The name of the database can be changed in the above query instead of "eMO".

Click below to download the above query in Note pad from google Drive

Download