I am using SQL Server 2012 and I have only 40GB free space but the transaction log is taking over 90GB space.
So is there a way to split this transaction log?
Is There a Way to Split SQL Server Transaction Log?
Resolved
SQL
CM
Community Member July 18, 2015
2 replies
929 views
Reviewed by moderators
2 Answers
First you take a backup of your transaction log file then choose the simple recovery model.
I hope this helps you: nnAlter database < databasename> set Recovery simplenUSE < databasename> nDBCC SHRINKFILE (< log_name>, 0, TRUNCATEONLY)nGOnAlter database < databasename> set Recovery full