Home » Topic » Is there a way to Split SQL Server Transaction Log?

Is there a way to Split SQL Server Transaction Log?

Lincoln Burrows ~ Modified: July 18th, 2015 ~ ~ 1 Minute Reading

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

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • July 18, 2015 at 12:42 pm #363 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    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?

    July 20, 2015 at 12:30 pm #367 Score: 0
    Stephen West
    Moderator
    4 pts

    First you take a backup of your transaction log file then choose the simple recovery model.

    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

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.