Migration of Project Server From One Envirnoment to another

[waqas sarwar]

hey man

I use the Sql Backup and restore process to migrate the stuff but i am
unable to do this.

What i did.
1) took the backup of all 4 Project server and 1 Content DB backup
2)On new server restores all Database
3)create a new web application then replace the their content DB with
exisiting Content db(migrated from other envirnoment)
4)now trying to create new PWA instance using the exiting 4 Databases.

here the result.

Failed to provessioned......see event log.(All errors attached)

Please tell me how can i sucessfully migrate the stuff. also tell me where i
am wrong.

thanks



Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6958
Date: 7/1/2009
Time: 4:43:55 PM
User: N/A
Computer: GHKDIA
Description:
Provisioning 'projectserver': Database provisioning failed.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

*****************************************************************************************************************************
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 6993
Date: 7/1/2009
Time: 4:43:55 PM
User: N/A
Computer: GHKDIA
Description:
Provisioning 'projectserver': Failed to provision databases. An exception
occurred: Non project schema..

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
********************************************************************************************************************************
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Provisioning
Event ID: 7071
Date: 7/1/2009
Time: 4:43:55 PM
User: N/A
Computer: GHKDIA
Description:
Provisioning 'projectserver': One or more of the databases already contains
schema. When editing or creating a Project Server instance, you may specify:
* Four databases that do not exist
* Four existing, blank databases
* Four existing Project Server databases of the same version from the same
installation.
Combinations of blank, new, and existing databases are not allowed.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

 

[Andrew Lavinsky]

If I had to guess, it looks like you may have fatfingered the name of one
of the 4 databases when provisioning the PWA site. It needs all four to
be existing and from the same environment. From the error message, it looks
like it's trying to create 1 and restore 3 (or 2 and 2, can't tell). You
might also get this if you just created one of the databases in SQL without
having exported it from the original instance.

-A

 

[waqas sarwar]

Thanks Andrew,

Basically when we trying to use the Backup & restore operations for project
server Databases on Sql Server, We change the collation of DBs as per
recommendid by best practices.
Now we tried 2 different combination.

1) use the database which collations were changed .
Result is same.Provisiong failed.

2) Use the databases without collation changed
Result: we sucessfully created the instance and everything is working fine.

But we want to use the 1st combination as we want to implement it.

Please guide me accordingly.

Thanks

 

[Andrew Lavinsky]

Well, that's a different question. Recommend you post it back on the newsgroup
with the topic "Changing collation on Project Server databases"

Might get some better answers.

-A