MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Upgrade from SQL Server 2005 to SQL Server 2008 (where SSRS 2005 is in use)

  Asked By: Jean    Date: Nov 22    Category: MOSS    Views: 1934

We have MOSS 2007 Server fram and database is SQL Server 2005. We are planning to move to SQL Server 2008. What steps should we follow to migrate database from SQL Server 2005 to SQL Server 2008. We have SSRS 2005 ReportingS ervcies Integrated with MOSS 2007. Do we need to uninstall Reporting 2005 Add-in from MOSS 2007 and then install Reporting Add-in 2008.



2 Answers Found

Answer #1    Answered By: Indrajeet Patil     Answered On: Nov 22

One post that I saw states that you can backup the databases in 05, install the new instance of 08, then restore the databases on the new instance of 08. Here is a post from the sql  Server Side: www.packtpub.com/.../...erver-2008-in-three-steps. You will probably need to re-run the configuration wizard to detach and attach the databases to your SharePoint Farm. I am not 100% sure on SSRS, but I found this post: blog.tech4him.com/.../. Hopefully these are helpful.

Answer #2    Answered By: Xavier Hopkins     Answered On: Nov 22

Check out this blog post by Mike Watson: