SQL Server Performance

HOW To: Move Databases from UnClustered to Cluster

Discussion in 'SQL Server Clustering' started by Jon M, Dec 2, 2004.

  1. Jon M Member

    Hi 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=':D' />] I want to copy all system and user databases from the old server to the new server. <br /><br />Thanks,<br />Jon M
  2. Argyle New Member

    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.
  3. Jon M Member

    Thanks Argyle.
    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
  4. bradmcgehee New Member

    I have done this before by just detaching and attaching the databases.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  5. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. biged123456 New Member

Share This Page