How to move transaction log

[Former Member]

Hello

I wander how to move transaction log to another disk. I assume I have to

1.stop sap,

2. detach database

3. move folder (containing ldf file) to another disk

4. attach database with command like:

"Exec sp_attach_db 'PED'

'F:\PEDDATA1\PEDDATA1.mdf',

'F:\PEDDATA2\PEDDATA2.ndf',

'F:\PEDDATA3\PEDDATA3.ndf',

'F:\PEDDATA4\PEDDATA4.ndf',

'F:\PEDDATA5\PEDDATA5.ndf',

'F:\PEDDATA6\PEDDATA6.ndf',

'F:\PEDDATA7\PEDDATA7.ndf',

'G:\PEDLOG1\PEDLOG1.ldf'

"

[Former Member · Accepted solution]

Yes.

As i go through its look perfectly fine but still have a look on SAP Note 363018 - File management for SQL Server.

Regards,

Nikunj Thaker

[Former Member]

Hi jan Bo,

I want to know why you want to move the transaction log to another disk.

I mean, you want to move simply (want to know the procedure) or having some issue with transaction log?

The procedure you told is correct.But its risk.It may not attach after moving the transaction log.

Thanks & Regards,

Nagendra.