The transaction log for database 'MyDatabase' is full due to 'LOG_BACKUP'

Skapad av Kenny Westermark, Ändrad den Fre, 8 Okt, 2021 vid 3:55 E.M. efter Kenny Westermark

USE [master]
GO
ALTER DATABASE [MyDatabase] SET RECOVERY SIMPLE WITH NO_WAIT
GO

USE [MyDatabase]
GO
DBCC SHRINKFILE (N'MyDatabase_log' , 0, TRUNCATEONLY)
GO

USE [master]
GO
ALTER DATABASE [MyDatabase] SET RECOVERY FULL WITH NO_WAIT
GO

Felmeddelande