How To Move SQL Server Database Files To A Different Location

If you ever run into the problem where your database files are getting too large and you want to move the database files to a different drive with more storage then this tutorial will answer your question.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#SQLServer #MSSQLServer #MoveDatabaseFile

[danielrooein]

This worked nicely! Thanks for the great video!

[ledickin]

Very helpful, thank you.
For SQLServer Express the file permissions on a Windows computer, the userid is ‘NT SERVICE\MSSQL$SQLEXPRESS’
SQL Server Management Studio needs be opened as “Run as administrator” to allow the database to be attached.

[MyLubimishBabyLove]

And in which cases we need to use Detach/Attache or its always can be replaced by just moving db to offline? If I need also change the file name I also can use this method?

[jamescorbett]

Great Video, I'm stuck at file permissions, I can see that MSSQLSERVER has permission for the original file location, but I can't find that userid when granting permission in the new folder. I have also tried CPT South Austrailias 'NT SERVICE\MSSQL$SQLEXPRESS' which can't be found either. any help greatly appreciated.

[michelleurbano]

Nice vid ! 🎉 but a question if youre going to change the location of the database file that is inside a filegroup? is it the same way just modify file name and filepath directly?

[sai]

Is there a manual way of doing that without typing in the commands

[the_daftkid]

Is this applicable for a database transfer to an external drive? Thank you