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 MikeeOK 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

Status
Not open for further replies.
ToddF

ToddF

Programmer
Oct 17, 2002
5
US
I was not backing up a SQL Server database and the transaction log grew unchecked. I now do not have enough space to backup the database on the server.

Is it possible to just delete the transaction log. If not any suggestions on how to deal with this?
 
Sort by date Sort by votes
If you do not need your transactions then try:

backup log DBNAME with Truncate_Only

Hope this helps.
 
Upvote 0 Downvote
You'll need to shrink the log file after backing up. I recommend that you read the following FAQs.

faq183-1534 - Shrinking Databases and Logs - SQL 7 and Higher
faq183-1784 - How Do I Develop a Backup and Restore Strategy? If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:
 
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
1K
gmmastros
gmmastros
Auguy
  • Locked
  • Question
SQL 2014 Truncate Log File
Replies
2
Views
286
Auguy
Auguy
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
557
Andrzejek
Andrzejek
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
526
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
Restore a database with a backup having a damage transaction log.
Replies
3
Views
283
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top