Move SQL 2005 Instances
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)
MSSQL.4 Accounting
MSSQL.7 SharePoint
MSSQL.10 Core
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.
Jason
MSSQL.1 Default Instance (MSSQLServer)
MSSQL.4 Accounting
MSSQL.7 SharePoint
MSSQL.10 Core
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.
Jason
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The .2, .5 etc are reporting/OLAP folders, they are like "instances"
if you get into problems when migrating/removing files from them, here's someone who has been there
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1206916&SiteID=1
it should not be a problem if you're reinstalling the same set of features, then attaching existing databases from the data folder
if you get into problems when migrating/removing files from them, here's someone who has been there
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1206916&SiteID=1
it should not be a problem if you're reinstalling the same set of features, then attaching existing databases from the data folder
ASKER
Is that the best way to move everything - by reinstalling the instances? Is it possible to just move everything from one disk to an other on the same machine. I have moved all of the system and user databases but there are still the olap instances, and some other db files in the original instance folders (distmdl.mdf, mssqlsystemresources.mdf)
thanks
thanks
ASKER
MSSQL.2 and MSSQL.5 where the only thing in them is a folder called OLAP.
I also have a couple of folders like MSSQL.3 where the only thing in them is a folder called "Reporting Services".
It does not look like they belong to any existing instance. Do I need them or can these directories be deleted?
My running instances are in the following folders. MSSQL.1, MSSQL.10, MSSQL.7, MSSQL.4