Tag: move database files

  • How to move data and log file using Alter statement

    You can use Alter command to move data and log file.

    Sample Script

    -- Moving data file to E:\ drive
    ALTER DATABASE tempdb
    MODIFY FILE (Name = tempdev,FILENAME = 'E:\tempdb.mdf')
    -- Moving log file to E:\ drive
    ALTER DATABASE tempdb
    MODIFY FILE (Name = templog,FILENAME = 'E:\templog.ldf')