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.
Many thanks have always been very scared to touch dbs but your videos are informative and really help. Have subscribed , why dont u setup.somerhing on udemy
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!
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
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.
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
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.
@@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')
How to move master Database from one drive to another.
ua-cam.com/video/oC3n2xRqmNY/v-deo.html
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.
I will make a separate video to move system databases and then post the link in comments section
Good way of explanation very useful
Still remains actual, thank you !
Bro this video is Gold. thank you so much
Hello Sir
Your content is too much informative and very easy to understand. Please post the videos on performance tuning and related issue solutions
Sure, I will post
Many thanks have always been very scared to touch dbs but your videos are informative and really help. Have subscribed , why dont u setup.somerhing on udemy
Thank you bro ❤
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!
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
It will work also when file names changed? And what about filestream?
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.
Thank you very much!
after attach the sql is ok, but how we know it is same functioning as database before dettach?
Good explanation sir, but I am getting an operating system error,
how to overcome this problem
sir please upload how to create Clustering in sql server and also upload video for Migration with practical demo
Thank you bro
Nice Tip...but is it recommended to change the default DB locations settings?
It is a good practice. However it should done as per your requirement.
nice
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
Yes, they can login
Thank you 😊
Hi BK
Is there any down time to move
(C to F) the data files and log files..
1.Backup and restore..
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.
@@righttolearnbk thanks for the update BK
thanks
Access got denied, so how can I give access to that
Where did you get this error exactly.
You Can share the image to me via Instagram or through email
@@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')
@@abhay6276 just give yourself access to the folder .
Should I move MDF file by others name
You can rename after moving them to new location
@@righttolearnbk ok