October 14, 2008 at 9:14 am
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
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
My bad! I meant to say detach databases, not jobs.
October 14, 2008 at 9:45 am
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