Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How do I  Move/Delete .TRN Files

Posted on 2009-02-10
Medium Priority
Last Modified: 2012-05-06
We have a server running an ERP that creates daily .TRN files which has filled a partition to its entirety.  I have 48k available, what can I do?  I am not a SQL expert so I am looking for some steps in moving these files.
Question by:camoIT
  • 2

Assisted Solution

funnymanmike earned 600 total points
ID: 23600415
in SMS create a backup plan, the backups will clean up the transaction logs for you.

Accepted Solution

funnymanmike earned 600 total points
ID: 23600439
Run SQL Server Enterprise Manager
Drill down and find Database Maintenance Plans
Right click to create a new Maintenance Plan
Follow the wizard, it will guide you. just answer the questions its asking
when you get in, you will see a screen that says back up the transaction log as part of the maintenance plan, ensure you check this so that gets backed up as well
LVL 39

Assisted Solution

BrandonGalderisi earned 400 total points
ID: 23601602
Those are transaction log backup files.  You can delete any thing older than you need to recover as long as you have a full database backup.  You don't want to delete any newer than your latest FULL database backup.  

You may, depending upon what your needs are, want to consider changing your recovery mode to SIMPLE.  Here is an article that chapmandew has written on the topic.


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Integration Management Part 2
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question