Skip to Content
0
Former Member
Dec 07, 2009 at 10:33 AM

How to move transaction log

65 Views

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'

"