Best Practices Recommendations
When you create a new database, specify separate drives for the data and log. To move files after the database is created, the database must be taken offline. Move the files by using one of the following methods:
-
Restore the database from backup by using the RESTORE DATABASE statement with the WITH MOVE option.
-
Detach and then attach the database specifying separate locations for the data and log devices.
-
Specify a new location by running the ALTER DATABASE statement with the MODIFY FILE option, and then restarting the instance of SQL Server.