BACKUP LOG Terminating abnormally, MSG 3013, LEVEL 16, STATE 1, LINE 4
I got the below error when we trying to take the transaction log backup of model databases. So as a part of solution, we change the recovery model of the model database from FULL to SIMPLE and then immediately changed it from SIMPLE to FULL. This resolved the issue.
There is also a possibility that the below commands might not work in all cases.
In that situation RESTART SQL server instance. This worked in my environments.
USE [master] GO ALTER DATABASE [model] SET RECOVERY SIMPLE WITH NO_WAIT GO USE [master] GO ALTER DATABASE [model] SET RECOVERY FULL WITH NO_WAIT GO
Comments