SQL Server move database or datafile

Move data or log files

1. Run the following statement.

ALTER DATABASE database_name SET OFFLINE;

2. Move the file to a new location

3. For each file you have moved, run the following statement

ALTER DATABASE database_name MODIFY FILE (name = logical_name, FILENAME = ' new_path\os_file_name ');

4. Run the following statement

ALTER DATABASE database_name SET ONLINE;

5. Verify file changes by running the following query

SELECT name, physical_name as Currentlocation, State_desc

From Sys.master_files

WHERE database_id = db_id (N ' <database_name> ')

Go

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/