How to move Microsoft SQL Server database to another drive partition

What would you like to read next?

14 Comments

  1. OK, but what to do when on Locate Database Files doesn’t show me other drive than C. And if i execute attach command it says: “Directory lookup for the file “D:TESTTest.mdf” failed with the operating system error 5(Access is denied.).”. The user is admin on the PC and i checked all boxes for server roles. My guess is Access is denied is related to the Drve, not he file. I check Advanced security settings for the drive, but it doesn’t allow me to change – i only see that the user has full control.

  2. After attaching, the property –> option –> state –> db read only must be set to False.

  3. After attaching, the property –> option –> state –> db read only must be set to False.

  4. Anand, I believe that Mr. Walker finds the METAPHOR of water fountains, as a reference to racial segregation, to be “latently racist”, whatever that means. I see it as a reference to a time when racism was endemic to our country. Some people see no humor in such historical references. Or perhaps it is the very word; segregation, that he finds objectionable.

  5. Superfluous, yes, but the apparent humor of it made your post MUCH more enjoyable. I, for one, liked it.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share via
Copy link
Powered by Social Snap