Great video for beginners. One thing I'd like to add that could help a beginner is that after you've taken the DB offline, and you're ready for the file move portion, be weary of the permissions on the file (especially if you're moving from one drive to another). Robocopy is really great about keeping the permissions on a file. I think W10 moves the permissions along with it, but it's not that way in W7, or on some server OS'. Personally, I like to do them manually one at a time, as well. I end up cutting, pasting, then right clicking the file, selecting properties, security, edit, add, and then ensuring that the service that runs SQL Server has permissions to it (for example: 'NT Service\MSSQLSERVER'). Not sure if you can do a straight move in W7? Anyway... figured this might shed some light on some hardships I've experienced in the past with something like this.
Great video for beginners. One thing I'd like to add that could help a beginner is that after you've taken the DB offline, and you're ready for the file move portion, be weary of the permissions on the file (especially if you're moving from one drive to another). Robocopy is really great about keeping the permissions on a file. I think W10 moves the permissions along with it, but it's not that way in W7, or on some server OS'. Personally, I like to do them manually one at a time, as well. I end up cutting, pasting, then right clicking the file, selecting properties, security, edit, add, and then ensuring that the service that runs SQL Server has permissions to it (for example: 'NT Service\MSSQLSERVER'). Not sure if you can do a straight move in W7? Anyway... figured this might shed some light on some hardships I've experienced in the past with something like this.
Even doing this through the GUI is not as clear as this. Very nice video! Thank you!
Thanks Jake! Wasn't aware you even could do it all in the GUI. Add and remove, sure.
Thank you, you are the best.
Thanks for a good tutorial.
👍 Keep it up Kevin