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
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