Is there a way to Split SQL Server Transaction Log?
Lincoln Burrows ~
Modified: July 18th, 2015 ~ ~ 1 Minute Reading
- This topic has 2 replies, 3 voices, and was last updated 9 years, 9 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
First you take a backup of your transaction log file then choose the simple recovery model.
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
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.