In order to resolve the issue, I have followed the steps below: 1) Taken the database offline and online 2) Executed the query given below : USE [your_databseName] GO ALTER DATABASE [your_databseName] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE('your_databseName_log', 1) ALTER DATABASE [your_databseName] SET RECOVERY FULL WITH NO_WAIT GO
