none
SQL 2005 Clusters to 2012 R2 Non-Cluster RRS feed

  • Question

  • Hey was looking for some guidance here. I have some old SQL instances, Here are the names I will use to describe them:

    SERVER1\Internal (Clustered 2005) 
    SERVER2\Internal (Clustered 2005)
    SERVER3\DMZ (Clustered 2008R2)
    SERVER4\DMZ (Clustered 2008R2)

    Ironically Servers 2 and 4 were going to replace 1 and 3 but the developers never moved off the old servers so I ended up supporting all 4.

    Now that it has been years, the databases on these systems are "legacy" and while they still need to be around they are not critical anymore. They currently sit on 12 power supplies worth of equipment generating alot of heat and power usage for nothing.

    I want to move both Server1 and Server2 to a single new instance:

    SERVER5\Internal  (Non-Clustered)

    I want to move both Server3 and Server4 to a single new instance:

    SERVER5\DMZ  (Non-Clustered)

    There are no name overlaps. What is the best way to go about this? Should I try to use the Database Copy wizard? If so from where? Logon's are urgently needed as I dont know the passwords to most of the SQL accounts. SQL Tasks would be a plus but not totally required. 

    What would you guys recommend to get to one server two instances? Thanks in advance! 


    Monday, July 15, 2013 4:09 PM

Answers

  • Best method which appears to me is Backup restore.Create new instances install SQL server 2012 and do backup restore and ur good to go.Make sure u copy logins,jobs  and packages.

    Question is why u want to move away from cluster u will be loosing HA capabilities for ur SQL server.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, July 15, 2013 5:39 PM

All replies

  • Best method which appears to me is Backup restore.Create new instances install SQL server 2012 and do backup restore and ur good to go.Make sure u copy logins,jobs  and packages.

    Question is why u want to move away from cluster u will be loosing HA capabilities for ur SQL server.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, July 15, 2013 5:39 PM
  • We are dropping HA as the hardware is out of warranty and the work load is no longer mission critical. 

    I ended up using this to get the user accounts over:

    http://support.microsoft.com/kb/246133

    Then did a backup and restore of each DB. Was hoping for a better way but I did use Powershell to script the creation of the backups / taking source offline and another powershell script to create the script that was used to do all of the restores.

    Tuesday, July 23, 2013 5:08 PM