Different methods to upgrade SQL Server 2005 to 2008
Posted on 2011-09-12
I have number of Oracle & SQL server 2005/2008 databases. I used to work with SQL server part time but seems I need to take care of them full time on our new upgrade project.
The latest work stack demands upgrading SQL server databases from 2005 to 2008. I have number of systems ranging from 10 GB to 200 GB and I am looking for a practical advice. I have done upgrade of some small dev 2005 databases by using detach/attach technique but not sure if I should try that on big database systems?
Is it also possible to upgrade the PROD systems with almost no downtime?
We use SQL server Analysis/Integration & reporting services. What do I need to do for them besides upgrading the software?
Can I run SQL server 2005/2008 on same box? I am thinking this because in case the upgarde fails I can go back to old 2005 version easily.