Blog
Projects
About
Backtrack:
Blog
›
Truncate transaction logs for …
Comments
Truncate transaction logs for SQL Server 2008 and up
posted on May 26th 2015, at 16:17
by
lunarg
Two methods of truncating the transaction logs for a database for SQL Server 2008 or newer:
Perform a backup to the nul device, essentially a "black hole":
BACKUP LOG [databaseName] TO DISK = 'nul:'
Temporarily set the recovery model to SIMPLE, then shrink the transaction log:
ALTER DATABASE databaseName SET RECOVERY SIMPLEDBCC SHRINKFILE('databaseName_log', 0, TRUNCATEONLY)ALTER DATABASE databaseName SET RECOVERY FULL
WARNING: truncating the transaction log without a backup may result in data loss in case of a database failure!
EDIT (26/05/2015):
You could attempt the backup/shrink routine without changing the recovery mode, but this will most likely onl
...
read more
add a comment
Tags
computer
windows
software
vmware
microsoft
exchange
linux
hardware
network
news
mac
home
powershell
office365
msoffice
server
sqlserver
ad
dell
soaring
internet
esx
sbs
rds
events
mssql
terminalserver
powercli
hp
virtualization
Archive
«
‹
March 2024
›
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Links
-
@harkx
-
Cats & Dogs
-
Jargon-free Security Guide
Quote
«
Safety is not a coincidence.
»
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs