We have a SQL Server 2008 R2 instance with the following features:
C:\ - Installation folder
D:\ - System DB Files, User DB Data files
E:\ - Log Files
We are definitely moving the system and user databases on D:\ and E:\ files to a new better storage (Drives G:\ and H:\ on the same server) and are going to follow the procedures mentioned in BOL/MSDN using ALTER DATABASE.
I have 2 questions:
(a) We want to move drive C:\ onto the new, better storage but our understanding is that since it installation files, we can't just move the drive. Rather, we would have to install SQL Server again on the new storage and then maybe restore the databases. Please confirm if this is correct.
(b) If we just move DATA and LOG Files our other issue is that we have about 75 databases to move. The only way we know is to script out the statements for each database. Is there an easier way to move this number of databases onto the new drive than scripting out for each?