Post reply

2005 upgrade

  • October 14, 2008 at 9:14 am

    #199766

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

    Thanks

    Amir

  • October 14, 2008 at 9:28 am

    #884708

    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

  • October 14, 2008 at 9:30 am

    #884710

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

  • October 14, 2008 at 9:45 am

    #884721

    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