restore and backup

[Koen Verwimp]

Hey,

I have a restore/backup problem.

HostA has project server installed with SQL2005.
HostB has project server installed with SQL2005.

HostA project databases in SQL2005 are backuped every night.
I want to restore the backup on HostB.

When i restore this 4 projectdatabases on HostB (archive, draft, publish and
report) and try to login on the webinterface on hostB ... i cannot login.

What do I have to do to make me Site administrator of that restored project
webspace?

I think he wants me to login as HOSTA\Administrator instead of
HOSTB\Administrator because HOSTA\Administrator was the site administrator of
the original project webspace.

Can someone help me?

Thanx,
Koen

 

[James Fraser]

Hey,

I have a restore/backup problem.

HostA has project server installed with SQL2005.
HostB has project server installed with SQL2005.

HostA project databases in SQL2005 are backuped every night.
I want to restore the backup on HostB.

When i restore this 4 projectdatabases on HostB (archive, draft, publish and
report) and try to login on the webinterface on hostB ... i cannot login.

What do I have to do to make me Site administrator of that restored project
webspace?

1) On Host B, go to the SSP site and delete the existing Project Web
Access site.
2) Restore the databases.
3) On Host B, in the SSP web site again, create a new Project Web
Access site pointing at the restored dbs. This will ask what user
account should be made the administrator. During the provisioning,
that account will be added to the Administrators group.


James Fraser

 

[Koen Verwimp]

Problem solved!

thanx

1) On Host B, go to the SSP site and delete the existing Project Web
Access site.
2) Restore the databases.
3) On Host B, in the SSP web site again, create a new Project Web
Access site pointing at the restored dbs. This will ask what user
account should be made the administrator. During the provisioning,
that account will be added to the Administrators group.


James Fraser