I thought I've done this before...fairly easily, but it seems I'm missing a step I may have forgotten. I have several DBs that need to have ONLY their corresponding LDF (log) files relocated to a different drive. I thought the procedure was simply:
1. Rt-click on DB -> Tasks -> Detach
2. Move the LDF file to the proper drive
3. Rt-click on DATABASES heading -> Attach
4. Click the 'Add' button, select the DB and re-attach.
..but alas, I am getting an error. An 'access denied' error. I shouldn't because I'm logged on as Domain Admin. I have privileges that I need. I didn't stop any SQL services because...well...it's during the day and I can't. My assumption is that is what I need to do, but I didn't think I needed to do that to simply detach/attach a DB. I can't move the LDF file, but I can copy it (get the access denied error). But, I need to move it (simply move/paste operation in Windows). Well, I did try and see if the copy alone will work. So, I have a copy in the location I want it, then tried to re-attach the DB and I get a long error that, in the middle of it, says access denied. Any idea what I'm doing wrong here?