Relocate Transaction Log

[Former Member]

Hi,

What is the procedure for relocating the transaction log files (\<SAPSID>LOG<N>) from one drive to another. The new drive is larger.

Thanks,

Jim

[Former Member]

Thank you, this is just what I needed.

[Former Member]

Hi,

In case of MSSQL you need to following steps.

1. Stop the database.

2. Detach the database.

3. Copy the transaction log file from the orig destination to the new destination.

For eg ( from d:\MSSQL\LOG\TLOG1.ldf to e:\MSSQL\LOG\TLOG1.ldf)

4. Rename the transaction log file in the original destination.

5. Attach the database. During this it will show error with a cross mark as the transaction log is not present.

6. Here give the new location of the file (For eg e:\MSSQL\LOG\TLOG1.ldf)

7. Once the database is attached successfully, start the database.

In case any errors do reply or do give reward points if the answer was helpful.

Regards,

Suhas

[Former Member]

Hi,

follow sap note Note 363018 - File management for SQL Server

Part B : Moving the tempdb database

regards,

kaushal