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
Updates:
Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates
Post a Comment