Posted by – Check which database is using the old drive. This can be done with the following query.
|
1 |
SELECT name, physical_name AS CurrentLocation FROM sys.master_files |
– Write down the output and check which DBs are placed on the old drive.
– Set your database offline with the following query:
|
1 |
ALTER DATABASE database_name SET OFFLINE; |
– Move your physical DB files to your new location. Which given in the query above.
– Modify the following query to your database variables, and run it.
|
1 |
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name, FILENAME = 'new_path\os_file_name.mdf'); |
– Set your database online with the following query.
|
1 |
ALTER DATABASE database_name SET ONLINE; |
– Check with the first query if the replacement is successful.