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?
Best Answer
Yes, what you proposed will work, assuming that you use the same folder structure as existed on the old data drive.