Greetings the SQL Server data and log files on same physical drive ,how can i move the log files to another physical drive there is any script will solve this issues or any other way Thanks
You can do this by Detach/Atach as Madhu mentioned but it is offline operation... You can do this online... If you want to move only log file to different drive... I believe it can be done online by creating the new file on the new drive and you can empty the log file using the DBCC SHRINKFILE command and delete it... Check BOL for DBCC SHRINKFILE sytax and ALTER TDATABASE syntax... MohammedU. Moderator SQL-Server-Performance.com
