Restore from SQL DB: what is the right step???

[Vit]

Hi All,

I'm moving a PWA from a test environment to a production
environment...

I have backup 5 db:

Project_Draft
Project_Publish
Project_Archive
Project_Reporting
WSS_Content_Project...

my test environment is totally inaccessible but I have a back up of
those databases...

how can I restore them in a new server????

I have already Central admin running...

I have restore the 5 DB into the SQL Server....

now, what are the steps to make pwa works and get the data stored into
the test environment???

thanks all

Vit

 

[Atif Hassan Siddiqui]

Before creating PWA site REMEMBER,

PWA site can only connect to a database with an earlier schema level. Schema
versions levels are updated when you create the PWA site. PWA can not connect
to databases with a later schema level. To handle this, you need to update
your server installation. You can check the schema versions of database, by
running the following query on xxx-published database,

select version from versions


Create PWA site:
- Open sharepoint central administration.
- Select Shared Services Administration
- Click on your available Shared services Provider. If SSP does exist,
create one before going ahead.
- Click Project Web Access Sites
- Click Create Project Web Access Site
- On the next page enter site name and database information. Database
information will include the names of your RESTORED DATABASES NAMES.
- Click OK. From now you will be on the previous page i.e. Manage Project
Web Access Sites.
- on Manage Project Web Access Sites page click Refresh Status button until
you see the status of your newly created PWA site to Provisioned.
- Now click the link of PWA site. Bingo! your site is ready!

The newly created site will fetch the data from the restored databases which
you have already done.

 

[Vit]

Before creating PWA  site REMEMBER,

PWA site can only connect to a database with an earlier schema level. Schema
versions levels are updated when you create the PWA site. PWA can not connect
to databases with a later schema level. To handle this, you need to update
your server installation. You can check the schema versions of database, by
running the following query on xxx-published database,

select version from versions

Create PWA  site:
- Open sharepoint central administration.
- Select Shared Services Administration
- Click on your available Shared services Provider. If SSP does exist,
create one before going ahead.
- Click Project Web Access Sites
- Click Create Project Web Access Site
- On the next page enter site name and database information. Database
information will include the names of your RESTORED DATABASES NAMES.
- Click OK. From now you will be on the previous page i.e. Manage Project
Web Access Sites.
- on Manage Project Web Access Sites page click Refresh Status button until
you see the status of your newly created PWA  site to Provisioned.
- Now click the link of PWA  site. Bingo! your site is ready!

The newly created site will fetch the data from the restored databases which
you have already done.

Thanks, this is what
I did... but the only thing that it missed is the workspaces.... I
have the content db, but I don't know how to restore it...

I can easy restore pwa... but not the "subsites" where are stored
documents, risks, issues and so on...

any suggestion??? when and how can I restore the content DB???

thanks

Vit

 

[Andre Venter]

Vit ,

Any chance that you maybe have a farm Backup ? From there it will be easy to
restore the Content Db, and then use STSADM - o -Export http://url to extract
the workspaces and then restore them on the new site. i do not know if you
will be able to do it otherwise, maybe someone can enlighten us with the
method
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

 

[Vit]

Vit ,

Any chance that you maybe have a farm Backup ? From there it will be easyto
restore the Content Db, and then use STSADM - o -Exporthttp://urlto extract
the workspaces and then restore them on the new site. i do not know if you
will be able to do it otherwise, maybe someone can enlighten us with the
method
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

Hi Andre,

Unfortunately no... I just have the SQL DB....

thanks

Vit...

 

[Vit]

.... I have restore just the Project Server DB (Archive, Published,
Draft and Reporting), I have provvisoned the new PWA instance....

the only problem is that I canno do anythin in the PWA... as soon as I
add a new user it tell me that there is an error:

The resource could not be saved due to the following reasons:
An unknown error has occured.

what can be???


thanks

Vit

 

[Mask]

... I have restore just the Project Server DB (Archive, Published,
Draft and Reporting), I have provvisoned the new PWA instance....

the only problem is that I canno do anythin in the PWA... as soon as I
add a new user it tell me that there is an error:

The resource could not be saved due to the following reasons:
An unknown error has occured.

what can be???

thanks

Vit

Hello Vit,


Like you said, what can it be???

Take a look to this link:

http://blogs.msdn.com/brismith/arch...has-occurred-or-unknown-error-in-wss-3-0.aspx

and to have a better error message follow the link on 1st Comment on
the post above.


Best Regards,
Mask

 

[Mask]

Hi Andre,

Unfortunately no... I just have the SQL DB....

thanks

Vit...- Ocultar texto citado -

- Mostrar texto citado -

Hello again Vit,


I'm dealing with the same problem as you. I can show you some links
that I tried to follow to make Content_db work. So far I had no
sucess.

http://proj2007.blogspot.com/2008/10/steps-to-move-project-server-2007-from..html

http://blogs.msdn.com/brismith/archive/2007/10/24/backup-and-restore-what-are-the-options.aspx

http://blogs.msdn.com/daweins/default.aspx

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


I really suggest you try this methods in a testing enviroment.
Carefull when detach a bd from SQL Instance.

Problems that I'm facing:

1 - When trying to use Central Administration of SharePoint I cannot
add my hold content db because unique UID from restored db;
2 - When using command line do delete and add content db I loose my
pwa site instance from Shared Services Administration;
3 - When detaching a bd directly from SQL I couldn't make it work
again.

Lessons Learned:
1 - Always use "Perform and Restore Backup" from SharePoint Central
Administration, even if it ask you 100GB of free space on disk....(nc)


I'm trying to resolve this issue on my free time so it may take some
time to resolve it. If I find a solution I will let you know.


Best Regards,
Mask.

 

[Atif Hassan Siddiqui]

Hello Vit,



(If u forgot to backup content database and have deleted the database files
then use some file recovery software to restore data files and restore the
content database in some environment and just follow the 4th point from the
following steps to restore the content database).



Please read the following steps to backup, restore and re-attach the content
database to SharePoint site.



• Backup SharePoint content database from SQL Server

• Go to SharePoint Centre Administration --> Application
Management --> Content databases. Locate your SharePoint application and
remove the content database. This will detach SharePoint application and
content database. If you won’t do this, the link always exists and you will
not be able to restore the content database later because SQL Server assumes
the content database is still in use, and you will find you can’t kill that
process in the SQL Server.

• Restore the content database

• Go to SharePoint Centre Administration --> Application
Management --> Content databases. Click your SharePoint application and
attach the content database.

• Reset IIS by typing iisreset on command prompt or do it from
Windows Services console.

• Don’t forget reset SharePoint site collection administrator





For doing this through another way, please read this article
http://technet.microsoft.com/en-us/library/cc719751.aspx



Let me know if you have any other questions/queries.

 

[Atif Hassan Siddiqui]

Hello Vit,



(If u forgot to backup content database and have deleted the database files
then use some file recovery software to restore data files and restore the
content database in some environment and just follow the 4th point from the
following steps to restore the content database).



Please read the following steps to backup, restore and re-attach the content
database to SharePoint site.



• Backup SharePoint content database from SQL Server

• Go to SharePoint Centre Administration --> Application
Management --> Content databases. Locate your SharePoint application and
remove the content database. This will detach SharePoint application and
content database. If you won’t do this, the link always exists and you will
not be able to restore the content database later because SQL Server assumes
the content database is still in use, and you will find you can’t kill that
process in the SQL Server.

• Restore the content database

• Go to SharePoint Centre Administration --> Application
Management --> Content databases. Click your SharePoint application and
attach the content database.

• Reset IIS by typing iisreset on command prompt or do it from
Windows Services console.

• Don’t forget reset SharePoint site collection administrator





For doing this through another way, please read this article
http://technet.microsoft.com/en-us/library/cc719751.aspx



Let me know if you have any other questions/queries.