Blog
Projects
About
Backtrack:
Blog
›
Truncate transaction logs for …
Email this to a friend
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
Send a link to this post to yourself or a friend.
Send to e-mail
:
Your name:
Your e-mail:
Captcha:
Type the letters and numbers as shown.
Not readable?
Get another
.
Information entered is solely used for sending a one-time e-mail, and is not retained and/or passed on to a third party.
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
«
Safety is not a coincidence.
»
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs