Move User Database (.mdf and .ldf files) to another drive in SQL Server || Ms SQL

In this video i have explained with demo - how to move a user database mdf and ldf files from one drive to another drive using 5 simple steps.

Contents in the video.
1. Why do we move these files 1:09
2. Methods used to move User 1:57 database (.mdf & .ldf files)
3. Alter database method - 5 Step process
step 1 - 2:32
step 2 - 4:13
step 3 - 4:46
step 4 - 6:29
step 5 - 7:31

4. What are the points to remember to perform the activity 8:45
5. Bonus Tip 9:25

Click on below link to watch the video
Logical filename & Physical filename of a user database file.

[righttolearnbk]

How to move master Database from one drive to another.

[ChromaGraph]

Explanation was very clear and anyone with limited knowledge can understand and perform the task, I am not much in to DB however over customer has no knowledge about it and got to help, with this video my job is done, thanks Bro.

[bandraluyellappa]

Thank you! This video is very useful for everyone. Can you please do video for always on setup as well. If it was already made, would you mind please share the link of it. Thanks Again!

[sayaleelande]

Hello Sir

Your content is too much informative and very easy to understand. Please post the videos on performance tuning and related issue solutions

[michelleurbano]

Thank you for the vid. Very helpful but is the modify file to a new location also applies to the file inside in a filegroup?

Or you need to modify filegroup syntax then just change the filepath of the data file there? Or is there any extra step? When changing the location of the database file inside a filegroup

[Kingbezy]

Bro this video is Gold. thank you so much

[righttolearnbk]

I will make a separate video to move system databases and then post the link in comments section

[MyLubimishBabyLove]

It will work also when file names changed? And what about filestream?

[smempire]

sir please upload how to create Clustering in sql server and also upload video for Migration with practical demo

[shivamyadav-imkb]

Hi @BK

Could you please let me know how to move .MDF file from one drive to another drive in high availability mode(primary and secondary replica).

Thanks,
Shivam.

[jingtingong]

after attach the sql is ok, but how we know it is same functioning as database before dettach?

[jhoveldango]

How about the users login under Security Tab? Can they log on again after moving DB in different destination. Thanks in advance BTW very nice tutorial hoping for your response

[debasiskarmakar]

Nice Tip...but is it recommended to change the default DB locations settings?

[rajunimmaturi]

Hi BK
Is there any down time to move
(C to F) the data files and log files..
1.Backup and restore..

[veeravidyasagar]

Access got denied, so how can I give access to that