How to move MSSQL Database to another drive

– Check which database is using the old drive. This can be done with the following query.

– Write down the output and check which DBs are placed on the old drive.
– Set your database offline with the following query:

– 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.

– Set your database online with the following query.

– Check with the first query if the replacement is successful.

Leave a reply

Your email address will not be published.