September 27, 2010 at 9:39 am
Hi all,
I was assigned a task to migrate a SQL 2005 Production Server to another existing SQL 2008 Production Server. Can anyone explain me the complete procedure & things to be kept in mind while migrating the entire SQL 2005 Production Server to already existing another SQL 2008 Production Server ?
Thanx in advance..,
September 27, 2010 at 10:02 am
Have you looked in the Articles section of this site? There are numerous, well documented steps and checks like the one written by Banyardi Schmardi linked below:
http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/
I doubt you will find anyone having enough time to write up all of the checks and then steps to perform a full upgrade within this forum, but a little more digging around on your part will yield you all the results you could need.
Good luck
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 27, 2010 at 3:35 pm
Can anyone tell me whether we can migrate the Linked Servers while Migrating SQL 2005 Server to an existing SQL 2008 Server. And if we can, please tell me the procedure to do that..,
Thanks in advance..,
September 27, 2010 at 3:47 pm
I wasn't the best of help on your first question, so let me try to make it up. The linked server information, along with Maintenance Plans and SQL Agent Jobs, or SSIS packages are all stored in the MSDB database. In my most recent migration, I detached and moved the MSDB database (saved me a couple of hours of work).
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply