Reply To: Is there a way to Split SQL Server Transaction Log?
Andrew Jackson ~
Modified: 22-Jul-2015 ~ ~ 1 Minute Reading
I hope this helps you:
Alter database <databasename>set Recovery simple
USE <databasename>
DBCC SHRINKFILE (<log_name>, 0, TRUNCATEONLY)
GO
Alter database <databasename> set Recovery full