• joshua.post (6/6/2013)


    Is backing up the databases and restoring the best way, including Master and Model, or once the old server is shut down, can I just copy the files over? MDF etc?

    In the cluster, can I just delete the cluster resources for the IP and computer name but leave SQL running?

    What about moving over the SQL Integration Services components?

    Unless you have some custom modifications, you may forget about Master and Model. By moving the jobs via script, you eliminate one big reason for moving MSDB. If I remember correctly, MSDB will not restore to another instance unless they are running exactly the same version of SQL, right down to service pack and hotfix (i.e., cumulative update).

    The SQL cluster resources should have dependancy on the IP and Name, so SQL can not be left running (that I know of).

    I'm sorry, but I don't know specifically about the SSIS components. I'll ask a colleague who is knowledgable to chime in here.

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS