I am a university professor and have over a hundred student project databases using the developer edition of SQL 2005 and 2008 on a portable hard drive. All are disconnected from any server. I need to move these to a new hard drive but no file
system tool I can find will let me copy the .mdf or .ldf files. Each of these files has a single user with permissions and the user is a long alpha/numeric string that seems to have been generated by SQL. I can copy these files if I select each
file individually and give full control permissions to my current login. On some files I need to first take ownership. I just don't want to have to go in and do this manually for 200+ files scattered all over the drive.
I really need some sort of batch approach (including something that can be launched from within VB which I can use to navigate my drive's folder structure looking for .mdf/.ldf files) to let me change the permissions on these files. As I said, I have
a LOT of them and they are scattered around a deep folder structure organized by semester, course, project team, and sometimes project version. Further, the files accompany other files such as VB projects, report projects, SSIS projects, etc.
I have access to Windows Vista and Windows 7 for doing this.
View Complete Post