How to move data and log file using Alter statement
Posted by Jugal Shah on May 6, 2010
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')
