March 14, 2011 at 3:37 am
Hi
I'm in the process of upgrading our developement server from SQL Server 2008 enterprise to SQL Server 2008 R2 enterprise. We're not going to install a seperate instance but instead remove the default SQL Server 2008 instance and install the new R2 instance. Is there anything in particular that I have to watch out for?
This is my plan;
1) Backup master, model and msdb databases. No custom SSIS packages (except maintenance plans) strored in msdb.
2) Extract the logins from the master DB using sp_help_revlogin sp.
3) Uninstall SQL 2008.
4) Install SQL 2008 R2. (OS is Windows Server 2008 Standard)
5) Create logins from script.
6) Re-attach the databases. (Is this enough? I can't recall that I'll need to restore each DB).
7) Regarding SQL Agent jobs and maintenance plans, these are stored in msdb... I won't be needing them since I'll be creating new ones... thus performing a cleanup in the process. If however I'll need to revert to them at a later stage, restoring the msdb should do the trick?
Am I being to simplistic?
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
March 14, 2011 at 8:14 am
Why you haven't gone for in-place upgrade?
March 14, 2011 at 8:26 am
Bala' (3/14/2011)
Why you haven't gone for in-place upgrade?
Thanks for your reply...
Yes I can just go for a 'simple' upgrade and do any neccessary cleanup afterwards! In this way I won't have to worry about logins and permissions...
I've read that this option should be fairly straighfoward, has anyone encountered any problems with it?
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply