2005 upgrade

  • Hello, I hear one should detach all jobs prior to upgrading the SQL and then reattach. is this really necessary?

    Thanks

    Amir

  • I'm not sure what you mean by "detach all jobs". Do you mean script them out prior to doing an in-place upgrade?

    I've not done an in-place upgrade. I've always installed SQL 2005 in a new instance then migrated user databases, jobs, etc.

    Greg

  • My bad! I meant to say detach databases, not jobs.

  • Ah, makes sense now. I've heard you should backup up databases before upgrading, but I've never seen a recommendation to detach them.

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply