SQL Server Performance

data and log file in the same drive

Discussion in 'General DBA Questions' started by airport, Mar 11, 2007.

  1. airport New Member


    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

  2. madhuottapalam New Member

    you can use Detach/Attach method to move files to different locations

  3. MohammedU New Member

    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...


Share This Page