Skip to Content
author's profile photo Former Member
Former Member

Empty and delete one of Tlog file

Hi,

I want empty and delete one of transaction log file in our production system sap ecc6.0 on MS-SQL server 2008.

Can you please let me know the steps to do so.

Regards,

Kirthi S

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2012 at 07:29 AM

    Why do you want to delete this file?

    The transaction log file (ldf) is part of the database with the data files (mdf/ndf).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 18, 2012 at 07:46 AM

    Hi,

    check this note for details about SQL file management:

    363018: File management for SQL Server

    and the following ones about backup strategies:

    44449: Backup strategies with the SQL server

    1297986: Backup and Restore strategy for MS SQL Server

    1420452: FAQ: Restore and recovery with MS SQL Server

    Regards

    Leo

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.