SQL DBA – Move Database mdf & ldf files to another drive

SQL DBA – Move Database mdf & ldf files to another drive

Step #2.
ALTER DATABASE ManDB SET OFFLINE;
GO
Step #3.
Move the file(s) to the new location manually.

Step #4. Change the system catalog settings:

ALTER DATABASE ManDB
MODIFY FILE (
NAME = 'ManDB',
FILENAME = 'F:\SQLDBs\ManDB.mdf'
)
GO

ALTER DATABASE ManDB
MODIFY FILE (
NAME = 'ManDB_log',
)
GO

Step #5.

ALTER DATABASE ManDB SET ONLINE;
GO

Step #6.

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
Leave a comment below with your thoughts.
Add it to a playlist if you want to watch it later.

**Follow me Socially 😀

**LIKE ➡ SHARE ➡ SUBSCRIBE
Please Like, Subscribe and Share our tutorials :)