cancel
Showing results for 
Search instead for 
Did you mean: 

Empty and delete one of Tlog file

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank you very much

former_member204080
Active Contributor
Former Member
0 Kudos

Hi Murali,

Thanks a lot. It solved my issue.

kirthi

Former Member
0 Kudos

Why do you want to delete this file?

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