Upgrade SQL Server 2005 to 2008, meanwhile we need SQL 2005 still running during and after upgrade
Is there anyway to upgrade SQL Server 2005 to SQL Server 2008, and at the same time, we need to keep SQL Server 2005 still running during and after the upgrade. Because the services cannot be stopped during the upgrade. Appreicate it.
You can install a new instance of SQL 2008 and then migrate all of the components (databases, logins, jobs, etc) over to the new instance as time allows. You would need to update any application connection strings to reflect the new instance. You could also use DNS aliasing to help with that moving forward. This is, in my opinion, a cleaner way to upgrade. It gives you a way to back out in the event the migration goes bump.
Before migrating first of all you need take a full database healthy backup. And keep a copy of backup for any disaster. After that you can easily upgrade to sql server 2008 and restore database on the upgraded sql server 2008.