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