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'
"