SQL Server Performance Forum – Threads Archive
HOW To: Move Databases from UnClustered to ClusterHi All,<br />Anybody knows how to move sql server databases from unclustered server to a cluster easily that is without so much pain? [<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />] I want to copy all system and user databases from the old server to the new server. <br /><br />Thanks,<br />Jon M
It’s not any different from copying them between two unclustered servers. System databases might be a different story. Any reason you need to move them all? You could just transfer your sql logins and sql jobs from your system databases to the cluster.
I just want to move them quickly without worrying about the errors that may arise such as orphaned users, etc. since I wasn’t given enough time. I was hoping I could just copy all system and user databases from my unclustered server and then paste them to my clustered server because I have tried doing this from two unclustered servers. Jon M
I have done this before by just detaching and attaching the databases. —————————–
Brad M. McGehee, MVP
IF there aren’t much logins, jobs & sysmessages involved from unclustered services then its better to export them and not to reattach/restore onto the clustered environment. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
I did the same thing on a large scale. I didn’t end up moving any of the system DBs, just recreating jobs/logins. Check outhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4529 for information into automating the process. The sp_fixusers reference worked well for me (I moved ~150 user DBs).