Restore PS2007 to New Production H/W

J

Jazi

Hi,
Have a 2007 setup on test servers with WSS content that we need to migrate
to production. The production is already setup and fully functional.
Appreciate if someone can help in outlining the steps that we need to take to
do that. We have full farm backup from the testing servers but we could not
do a restore. The restore fails complaining that the database already exists.

Thanks,
 
W

Wharton Computer Consulting

I am going to make an assumption that you are using SQL Enterprise and not
seeing the databases in the object explorer. I am also assuming that you
installed Project 2007 and defaulted to the SQL Express. So if this is the
case, use SSMS to open the SQL Express connection and remove the PS2007
databases.
 
J

Jazi

Yes I am using SQL enterprise in both the testing and production environment.
No Express edition is used.
 
P

Paul Conroy

Simply copy the databases (draft, published, reporting, archive,
pwa_wss_content) from your dev environment to the production environment.
(don't forget to take into account the required users permissions on the DB's
before you mover them)
 
J

Jonathan Sofer

This will not bring over the WSS content which is what Jazi requires. Jazi,
I don't think there is a way to copy over the WSS content only into a
working Project Server environment. It is difficult enough in 2007 to
migrate an entire environment over from one instance to another let alone
just the content. Someone can chime in here if they want but that is my
experience so far with the 2007 version.

Sorry I couldn't be of any help.

Jonathan
 
J

Jazi

Thanks Jonathon, I am sure there is a way to do that. I appreciate anyone who
has done it before to share the thoughts.
 
C

Claudio Hidetoshi

Hi, Jazi.

A friend of mine told that you can try making a backup of PWA site, at
Sharepoint Administration site "Operation/Backup", and restore it in another
server. I din't test it.

Another way that you would try is backup all six databases used by PWA
(draf, archive, published, reporting, content and config). Install a new PWA
with new empty databases (the names have to be the same as backup databases).
And Restore the databases.

If you don't have data in project sites, you can restore only draft,
archive, published and reporting databases.

And Good luck !

Claudio Hidetoshi
Rio de Janeiro - Brazil
 
J

Jazi

Thanks Paul but I have tried this and it did not work. I appreciate if you
can be more specific than the document by telling me which components you
select when doing the restore. The issues I face is I have in the new
environment a fully functional and provisioned PWA that I need to restore the
development data into it.

Thanks,
 
I

Ivanchem

Thanks Paul but I have tried this and it did not work. I appreciate if you
can be more specific than the document by telling me which components you
select when doing the restore. The issues I face is I have in the new
environment a fully functional and provisioned PWA that I need to restore the
development data into it.

Thanks,





- Show quoted text -
Click to expand...

Jazi.

Can you tell me about your problem? Did you migrate to new server or
not? I was wondering if you could tell how you made it.
 
Top