Home » Blog » Reply » Reply To: Is there a way to Split SQL Server Transaction Log?

Reply To: Is there a way to Split SQL Server Transaction Log?

Andrew Jackson ~ Modified: July 22nd, 2015 ~ ~ 1 Minute Reading

Home › Forums › Is there a way to Split SQL Server Transaction Log? › Reply To: Is there a way to Split SQL Server Transaction Log?

July 22, 2015 at 11:26 am #368 Score: 0
Andrew Jackson
Moderator
1 pt

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