Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

truncate transaction log programatically

Status
Not open for further replies.
dky1e

dky1e

Programmer
May 4, 2002
293
US
I am performing a large insert followed by a large delete. I want to truncate the transaction log right after.

How to backup transaction log programatically (I believe this will truncate)?

Are dbcc shrinkfile and dbcc shrinkdatabase my only options?

I don't want to use shrink file, becuse the location of the file might (and will) change.

Shrink db is too much.
 
Sort by date Sort by votes
Err...

I found what I was looking for right after I posted.

BACKUP LOG database_name WITH TRUNCATE_ONLY
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
928
gmmastros
gmmastros
Auguy
  • Locked
  • Question
SQL 2014 Truncate Log File
Replies
2
Views
250
Auguy
Auguy
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
490
Andrzejek
Andrzejek
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
464
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
Restore a database with a backup having a damage transaction log.
Replies
3
Views
233
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top