MSSQL Server modifies database file location This method has not been tested successfully

2. --View the current storage location
4. Select database_id,name,physical_name as currentlocation,state_desc,size from sys.master_files
6. where database_id=db_id (N' database name ');
10. --Change the location of the file to take effect the next time
12. --TESTDB is the database name,
14. Alter database name modify file (name = file name (does not contain suffix), filename = ' document store path ');
16. Alter database name modify file (name = file name (does not contain suffix), filename = ' document store path ');
18. eg.
20. alter database testDb modify file ( name = testDb, filename = ' G:\SQL_DATA\testDb\testDb.mdf ');
22. alter database testDb modify file ( name = testdb_log, filename = ' G:\SQL_DATA\testDb\testdb_log.ldf '  );
26. --Modify the default database file storage location (immediate effect)
28. EXEC Xp_instance_regwrite
30. @rootkey =' HKEY_LOCAL_MACHINE ',
32. @key=' software\microsoft\mssqlserver\mssqlserver ',
34. @value_name =' Defaultdata ',
36. @type =REG_SZ,
38. @value =' E:\MSSQL_MDF\data '
40. GO
42. --Modify the default log file storage location <span style= "Font-family:arial, Helvetica, Sans-serif;" > (immediate effect) </span>
44. EXEC Master. Xp_instance_regwrite
46. @rootkey =' HKEY_LOCAL_MACHINE ',
48. @key=' software\microsoft\mssqlserver\mssqlserver ',
50. @value_name =' Defaultlog ',
52. @type =REG_SZ,
54. @value =' E:\MSSQL_MDF\log '
56. GO

MSSQL Server modifies database file location This method has not been tested successfully