How do I  Move/Delete .TRN Files

Posted on 2009-02-10
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
    LVL 5

    Assisted Solution

    in SMS create a backup plan, the backups will clean up the transaction logs for you.
    LVL 5

    Accepted Solution

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    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.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now