In our current scanario log and data file on the same drive, I want to move
the log file into another drive for optimization and database is in use. how
can I


Current Scanario :-

MyDB1_DATA 1 C:\MSSQL\data\MyDB1.mdf
MyDB1_TLOG 2 C:\MSSQL\data\MyDB1.ldf

Desiring Scanario

MyDB1_DATA 1 C:\MSSQL\data\MyDB1.mdf
MyDB1_TLOG 2 D:\MSSQL\data\MyDB1.ldf

[quoted text, click to view]

You cannot do this while the database is in use. One easy alternative is to
detach the database and move the log file to the new drive. When you attach
the database to the server, specify the new location of the logfile.

--
Anith