• what you really want to do is a side by side server upgrade.

    on the 2008 server, you script out stuff, and run the scripts on the new server. no restoring is involved.

    i can assume you've got the backup of all the databases themselves covered, but from experience, that's not the whole puzzle:

    was there a reporting service on that machine? you need to backup the encryption key, and then import that key in the new reporting services.

    ditto for any Anaysis services stuff? backing up to *.abf files and restoring is pretty quick.

    did you have any procedures, functions or tables in the master database? script em out.

    any server triggers? script them out as well.

    script out logins via sp_help_revlogin.

    did you have any wierd providers(AS400?) on the original machine that was used for Linked servers? you might need to install those providers on the new machine.

    script out linked servers. you have to change the script for remote logins that had passwords to the "Real" password, as that scripts out with ### signs.

    script out any database mail settings.

    How about Credentials that might be used for various processes? you'll need to recreate those.

    tied to that, you have operators in msdb that need to be recreated.

    now that you are in msdb, script out the jobs. make sure you physically copy any SSIS packages that might be called via those jobs too. if the packages are in the msdb database, you might need to extract them out to disk to redeploy them. there's a powershell script I've used for that

    when you restore the databases, make sure you update statistics on all databases!

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!