SharePoint By Yagya Shree

Migrating SQL 2005 [32-bit] to SQL 2008 [64-bit] with SharePoint and Reporting services integration

leave a comment »

àYou have Following Questions:

  1. You are looking for a way to move the entire SharePoint farm databases from SQL server 2005 [32-bit] on server 2003 to SQL server 2008 [64-bit] on server 2008?

 

  1. You are looking for a way to move the SQL reporting services from SQL 2005 to SQL 2008?

 

  1. What changed to be done on SharePoint side?

 

Information:

 

Migrate databases

http://technet.microsoft.com/en-us/library/cc263299.aspx

 

How to move databases between computers that are running SQL Server

http://support.microsoft.com/kb/314546

 

Introduction to Backup and Restore Strategies in SQL Server

http://msdn.microsoft.com/en-us/library/ms191239(SQL.90).aspx

 

How to: Migrate a Reporting Services Installation

http://msdn.microsoft.com/en-us/library/ms143724.aspx

 

Reporting Services Configuration Files

http://msdn.microsoft.com/en-us/library/aa972211(SQL.80).aspx

Written by Yagyashree

May 1, 2009 at 5:23 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: