Upgrade from SQL Server 2005 to 2008 r2
in [Server Configuration]
|
Prev: Another Date conversion problem
Next: Cannot find a particular record by searching on non-primary key
From: dboon6767 on 10 Jun 2010 20:46 Hi, I'm a novice DBA looking after a DB, there are about 100 users in 3 offices. I'm thinking to upgrade to sql 2008 release 2 from sql 2005. Anyone gone through the process? did you have any notable issues? Should I do any specific 2008 R2 training before I upgrade? Do you recommend any books? thanks in advance...Dav.
From: John Bell on 11 Jun 2010 06:35 On Fri, 11 Jun 2010 00:46:40 GMT, "dboon6767" <u60804(a)uwe> wrote: >Hi, > >I'm a novice DBA looking after a DB, there are about 100 users in 3 offices. > >I'm thinking to upgrade to sql 2008 release 2 from sql 2005. > >Anyone gone through the process? did you have any notable issues? >Should I do any specific 2008 R2 training before I upgrade? Do you recommend >any books? >thanks in advance...Dav. Hi The first step will be to check out the upgrade advisor. It will depend on the complexity of the applications check out http://msdn.microsoft.com/en-us/library/bb677622.aspx for some advice. I would not recommend gettng a book for this task as most books don't cover it in enough detail (as it is a pretty impossible task to do so!). The more preparation you do the easier it should be, any issues you can eliminate before the upgrade the fewer things to go wrong during the upgrade. Make sure you plan contingencies for failure at different points as well as success, then you will remain in control. John
From: dboon6767 via SQLMonster.com on 16 Jun 2010 14:14
Thanks for the advice.. Yeah, i've started reading through the MSDN....... yeah there is certainly a lot of info there... John Bell wrote: >>Hi, >> >[quoted text clipped - 6 lines] >>any books? >>thanks in advance...Dav. > >Hi > >The first step will be to check out the upgrade advisor. It will >depend on the complexity of the applications check out >http://msdn.microsoft.com/en-us/library/bb677622.aspx for some advice. > >I would not recommend gettng a book for this task as most books don't >cover it in enough detail (as it is a pretty impossible task to do >so!). > >The more preparation you do the easier it should be, any issues you >can eliminate before the upgrade the fewer things to go wrong during >the upgrade. > >Make sure you plan contingencies for failure at different points as >well as success, then you will remain in control. > >John -- Message posted via http://www.sqlmonster.com |