SQL 2008 Database Migration

1. Modify the Migration path

Use master
GO
ALTER database name--master data
MODIFY FILE (name= ' database name ', filename= ' F:\DataBase\ database name. mdf ');
GO
ALTER database name--log data
MODIFY FILE (name= ' database name _log ', filename= ' F:\DataBase\ database name _log.ldf ');
GO
ALTER database name--file stream data
MODIFY FILE (name= ' platformfiles ', filename= ' F:\OA_PLUS\PlatformFiles ');
GO

2. To stop the SQL Server instance, you can stop under SQL Server Management Studio Configuration tool under SQL Server Config Manager. The net STOP MSSQLServer command is also available for implementation.

3. Manually move those data files or log files to the corresponding directory (that is, the filename corresponding to the above command)

4. Restart the SQL Server instance to verify that the data file migration was successful.

Test:
SELECT name, physical_name from Sys.master_files
WHERE database_id = db_id (' database name ');