0

I've got a SQL Server 2008 (std) with 19 DBs. Because I'm replacing my SAN, I need to move all the DB files to a different volume. I've moved individual DBs before using MS's recommended method: detach DB, move files, reattach. But I really don't want to do that in this case, partially out of lazyness, but also because some of the DBs belong to SharePoint and have a bunch of hex at the end of the name, which could potentially get messed up.

So my idea is to shut down the SQL server services, move all the files at once, dismount the old volume, and change the drive letter of the new volume to that of the old one.

Would this work? Is there a better way?

1 Answer 1

1

Yes, what you proposed will work, assuming that you use the same folder structure as existed on the old data drive.

3
  • Thanks. In your opinion, would this be the easiest way to do it?
    – 1.618
    Feb 25, 2013 at 20:03
  • 1
    +1 for this method. I've this many, many times. The only thing is that you want to be sure to copy the security ACLs for the files and folders onto the new drive as well or the server may not be able to open the files. Feb 25, 2013 at 22:15
  • Yes, that is the easiest way to do it. Personally I'd use Robocopy to just duplicate the structure, including the "/SEC" switch to copy security ACL's. Feb 26, 2013 at 20:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .