question

yxzhou624 avatar image
yxzhou624 asked

Upgrade SQL server 2005 to 2008

A server of my company is running SQL server 2005 with 32bit. Now we would like to upgrade it to SQL server 2008 with 64 bit. But the SSRS is running on that server and must run all the time. What should we do to upgrade while keeping the SSRS running? Or it we have to shut down the SSRS, how long will be the down time? Appreciate it.
ssrsupgradesql server 2008sql server 2005
1 comment
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

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 ·
So you are doing an in-place upgrade? Given any thought to installing a new instance and then migrate things over?
0 Likes 0 ·

1 Answer

· Write an Answer
jason_clark03 avatar image
jason_clark03 answered
You may have look on this msdn to know in detail: https://msdn.microsoft.com/en-us/library/ms143747.aspx also look here: https://msdn.microsoft.com/en-us/library/ms403392.aspx?f=255&MSPPError=-2147217396
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

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.