SAP MS SQL log location at 2 different location

[SAPSupport]

transactional logs are happeining at the 2 places as below:
1.D:\UEPLOG1\UEPLOG1.ldf
2. D:\Microsoft SQLServer\MSSQL14.UEP\MSSQL\LOG\UEPLOG2.ldf

We want to keep only one log location under D:\UEPLOG1.

What procedure should be followed ? DO we need to detach first and move log2 files into log1 folder and again attach database. OR

we can stop SAP and from studio we can change location directly to D drive.

We do not get any supporting document or SAP note to follow on this approach. Kindly suggest.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear customer

You can use the DBCC SHRINKFILE ... EMPTYFILE to move one transaction log data into the other one in order to remove an unwanted log file.
After that transaction log is empty, you can use ALTER DATABASE REMOVE FILE to remove the file.

Truncating a log breaks the backup chain and leaves you vulnerable to the last full / differential backup. You should immediately take a full database backup to restore the transaction log chain.

Best regards,

Cherry

SAP Support