• It works!

    I created a new database with four tables, 1 million rows each, backed it up, restored it to the old server. It restored ok. The sum of values in a numeric column in the source matches the sum in the target.

    As Gail mentioned, I need to patch this server. Can I install Service Pack 4 without installing 1, 2, 3, 3a first?