question

yxzhou624 avatar image
yxzhou624 asked

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.
sql-server-2008upgradesql server 2005
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image
JohnM answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.