March 29, 2010 at 2:52 am
Hi,
We are in the process of rebuilding a cluster with new hardware. The current 2-node cluster is running SQL Server 2005 (Server A) and the new cluster has SQL Server 2008 (Server B).
The user databases will be detached from Server A, the MDF and LDF files will be copied to Server B and attached. Don't think the SQL Version difference will be a problem?
But what about the system databases? I was thinking of creating a backup of each on Server A and restoring on Server B, but I don't think that is possible with the difference in SQL version?
My question then is how do I get all the information currently stored in the SQL 2005 system databases on the new SQL 2008 system database? I don't want to lose any logins, job or SSIS data etc.
Any suggestions?
March 30, 2010 at 3:32 am
not sure but if upgrade advisor be helpful in system database
----------
Ashish
March 30, 2010 at 9:58 am
Casper101 (3/29/2010)
Hi,We are in the process of rebuilding a cluster with new hardware. The current 2-node cluster is running SQL Server 2005 (Server A) and the new cluster has SQL Server 2008 (Server B).
The user databases will be detached from Server A, the MDF and LDF files will be copied to Server B and attached. Don't think the SQL Version difference will be a problem?
But what about the system databases? I was thinking of creating a backup of each on Server A and restoring on Server B, but I don't think that is possible with the difference in SQL version?
My question then is how do I get all the information currently stored in the SQL 2005 system databases on the new SQL 2008 system database? I don't want to lose any logins, job or SSIS data etc.
Any suggestions?
Hi
you can't migrate the system databases, don't even bother trying or you'll hose the system.
You could in place upgrade the system or script out all required objects and apply to the new instance of SQL Server. There are support scripts that export logins, etc from one instance to another. You can also script jobs, etc from within SSMS
PS. next time you may want to post in the appropriate forum (SQL Server 2008 High Availability) 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply