MSSQL Truncate TransactionLog Without Backup
With the following command you can truncate the transaction log withouot making a backup. Don’t forget to make a full backup afterwards.
ALTER DATABASE [DATABASENAME] SET RECOVERY SIMPLE WITH NO_WAIT
You can then maby do a shrink of the log file and then set the database back to FULL recovery.
ALTER DATABASE [DATABASENAME] SET RECOVERY FULL WITH NO_WAIT