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

Updates:

Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates

Post a Comment

Previous Post Next Post

Most Visited

Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates

Search Content of www.potools.blogspot.com @