Thursday, April 12, 2012 2:41 PM
We originally set up a Project server 2007 system using SQL server 2005 for the backend DBs. Now we want to manually move those Databases/instance to a SQL server 2008 environment. Is this possible? What are the possible options?
Thursday, April 12, 2012 2:57 PM
Thursday, April 12, 2012 3:31 PM
Yes, SQL 2008 is supported. Migrating to a new SQL server by moving the databases is fine providing you have used a SQL Alias / DNS alias for the SQL 2005 Server when installing Project Server 2007. If you haven't you will need to create a SQL Alias (on all app / web servers) / DNS Alias that points the old SQL 2005 server name to the new SQL 2008 server name.
Highl level steps below:
- shut down the app / web servers
- take full DB backups of all SharePoint and Project Server databases
- script out the delete expired session SQL job
- Copy these to the new SQL 2008 server
- Restore the DBs with the same names to the SQL 2008 server
- execute the script to create the delete expired sessions job
- Set up the permissions for the accounts on the new SQL 2008 server
- either repoint or create the SQL aliases / DNS alias for the SQL server
- configure SQL Analysis services
- turn on all web / app servers
- Test the farm
Friday, April 13, 2012 3:32 PM
With regards to the "configure SQL Analysis services" part, is a general installation/configuration or does it have to becustomized further for our environment and what links would you recommend other than the below?
thank you very much :-)
Friday, April 13, 2012 3:40 PM