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

Подписаться 13 тыс.

Просмотров 22 тыс.

50% 1

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.
• Rename Logical and Phy...

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@righttolearnbk 3 года назад

How to move master Database from one drive to another. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oC3n2xRqmNY.html

@righttolearnbk 3 года назад

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

@ChromaGraph 5 месяцев назад

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.

@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

@righttolearnbk Год назад

Sure, I will post

@Kingbezy 2 года назад

Bro this video is Gold. thank you so much

@MyLubimishBabyLove 5 месяцев назад

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

@aniketshelke9201 3 месяца назад

Thank you bro ❤

@michelleurbano0809 3 месяца назад

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

@jingtingong6177 3 года назад

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

@shivamyadav-im7kb Год назад

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.

@debasiskarmakar9158 2 года назад

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

@righttolearnbk 2 года назад

It is a good practice. However it should done as per your requirement.

@saikumarkakarla9924 2 года назад

Thank you bro

@rajunimmaturi7300 3 года назад

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

@righttolearnbk 3 года назад

We will have downtime to move existing database files from one drive to another. If we take backup & restore and create new database with files in new location, application string has to change to new database, so we will have downtime.

@rajunimmaturi7300 3 года назад

@@righttolearnbk thanks for the update BK

@sudhakarrao395 2 года назад

thanks

@rubinashaikh8925 2 года назад

Should I move MDF file by others name

@righttolearnbk 2 года назад

You can rename after moving them to new location

@rubinashaikh8925 2 года назад

@@righttolearnbk ok

@bandraluyellappa213 2 месяца назад

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!

@satishchowdary1390 3 месяца назад

Good way of explanation very useful

@smempire5027 3 года назад

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

@hargevorgyan 10 месяцев назад

Still remains actual, thank you !

@jhoveldango8730 Год назад

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

@righttolearnbk 11 месяцев назад

Yes, they can login Thank you 😊

@mladenzvjerac4073 2 года назад

Thank you very much!

@veeravidyasagar6123 2 года назад

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

@righttolearnbk 2 года назад

Where did you get this error exactly. You Can share the image to me via Instagram or through email

@abhay6276 Год назад

@@righttolearnbk Msg 5120, Level 16, State 101, Line 7 Unable to open the physical file "F:\MS SQL\SQL\SQLLogFile". Operating system error 5: "5(Access is denied.)". File activation failure. The physical file name "F:\MS SQL\SQL\SQLLogFile" may be incorrect. New log file 'E:\MS SQL\SQL\SQLLogFile\AdventureWorks2019_log.ldf' was created. Hello Balu, can you please look into this error...? i have executed below query pls check below Alter database AdventureWorks2019 modify file(name='AdventureWorks2017_log' , filename='F:\MS SQL\SQL\SQLLogFile')