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
linux
exchange
hardware
network
news
mac
powershell
home
office365
msoffice
ad
sqlserver
server
dell
soaring
mssql
internet
esx
rds
sbs
events
powercli
terminalserver
virtualization
antivirus
Archive
«
‹
December 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
«
Stripes on a tiger are hard to change.
»
The Noisettes
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs