Move SQL 2005 Instances
Posted on 2007-11-20
I have an installation of SQL Server 2005 with 4 instances running on it. The 4 instances running on it right now are:
MSSQL.1 Default Instance (MSSQLServer)
Drive D: has MSSQL.1, MSSQL.2, MSSQL.4, MSSQL.5 directories on it.
Drive C: has MSSQL.1 through MSSSQL.12 directories on it.
I would like to move everything to the C: drive. At that point I am going to back up the entire server, reconfigure it so that it has just one big C partition and restore to C:
How can I move all of the instances files from one drive to the other? Is it even possible? Where did all of the extra MSSQL.x directories come from? Are they being used for report server or something?
I know this is a lot and I appreciate your help.