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

    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
  2. madhuottapalam New Member

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

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


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page