Move user Database (.mdf and .ldf files) to another drive in SQL Server (DBA stuff)

Move user Database (.mdf and .ldf files) to another drive in SQL Server (DBA stuff)

#SQLServerBasics #DatabaseBasics #SQLwithManoj

[jcouture]

This video was a lifesaver tonight! Thanks for posting! It's still helpful nearly two years later. :)

[JGames]

What a great video.


The only thing that I had to change was the user permissions on the new folder where I dropped the database. MS SQL didn't want to start backup until I fixed the permissions on the folder itself.

[bhaveshzala]

Thanks!! for making this useful Video, I clearly understood for Moving mdb, ldb file to different location.

[mattsuserid]

Simple! Great explanation, thank you!

[cryogeneric]

You're the best! Saving me lots of time. :)

[ConorMcAuliffeOriginal]

This was the solution i was looking for, Thank you so much!

[byklaix]

Muy bien me sirvio mucho! gracias! thanks! my broo!

[SanthoshKumar-ipjl]

Hi Manoj...you explained its very clear, if you have any videos or document related NAS location. How to read the NAS location file and how to move and delete....please provide.

[jaime]

Thnaks, i wondering if there is way to do it everything from the sql managment studio command editor or from store procedure

[kenharkness]

So what do I do if I get the message: Database 'mydatabase' connet be opened because it is offline. When I try to do the ALTER DATABASE databasename MODIFY FILE ....

[AjayKumar-dngx]

Sir I had got an error while moving the data location I had taken the MDF files and while moving the log files it got an error and other data bases are not creating

[jingtingong]

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

[jahma]

Moving only LOG-file. Getting error that the primary file and log file don't match. AAARRRRGGGGHHHH

[rbrameshram]

please under stand my problem .iam moving the system datatabase files (mdf&ldf).ihave one error i can't solve that problem .iam movind model databse files D-drive to E- drive chainge logically ofter that go to configure mannager sql serve services stop ofter that move the system data base files one drive to another drive next start the services execute the error in display that's error
FCB::Open failed: Could not open file E:\systemdb\MODEL\MODELDB_MDF for file number 1. OS error: 2(The system cannot find the file specified.).that is the error .how to solve the error

[dharmendrachowdary]

If Data file and Log File size is more than 300gb, how much time it will take to complete this activity.
Or
Size is doesn't matter while moving

[tahirabbas]

Query is just taking so much time i.e more than 5 minutes but didn't executed.