Migrating Database File Locations

--1, modify file logical location--1) query file logical name, SELECT name Logical_name, physical_name as Currentlocation, State_descfrom Sys.master_ Fileswhere database_id = db_id (' Test ')--2) modify ALTER DATABASE test MODIFY FILE (NAME = test, FILENAME = ' M:\Program files\sq L server2008r2\test.mdf ') ALTER DATABASE Test MODIFY FILE (NAME = test_log, FILENAME = ' M:\Program files\sql server2008r2 \test_log.ldf ')

--2, offline or stop database alter test SET OFFLINE

–3, physically move the database files to the new location. –4, online or start the database ALTER test SET online–5, view effects SELECT name Logical_name, physical_name as Currentlocation, State_desc From sys.master_files WHERE database_id = db_id (' Test ') – Reference: http://msdn.microsoft.com/zh-cn/library/ms345483 (v= sql.90). aspx

Migrating Database File Locations