Tuesday, June 23, 2015

Shrinking database in SQL Server

Shrinking database requires to change recovery model from Full to simple.

ALTER DATABASE <database> SET RECOVERY SIMPLE
GO

DBCC SHRINKFILE (<log database>, 5)
GO

ALTER DATABASE <database> SET RECOVERY FULL
GO

No comments:

Post a Comment