backup - restore

M

maria pna

hello
could anybody tell me how to do a backup - restore of project server ddbb
and WSS database?
thanks!
maria
 
C

Chris Marriott

Hi

The backup of the project and WSS database is performed with SQL Enterprise
manager - it is not actioned wihin the Project Server

I can provide you a step by step process if required but I can not recommend
enough to get the advice of a SQL DBA to create a robust backup / restore
strategy for your project and sharepoint data ...

Let me know

--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer
 
R

Rolly Perreaux

hello
could anybody tell me how to do a backup - restore of project server ddbb
and WSS database?
thanks!
maria
Click to expand...


Hi Maria,

If you are just looking to backup the database, Chris has covered that.
But if you just want to backup a single Project Site (WSS) use the
STSADM.exe command with the BACKUP parameter on the WSS server.

Sample Syntax
stsadm.exe -o backup -url <url> -filename <filename> [-overwrite]

More info on STSADM.exe can be found at:
http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en
-us/stsk01.mspx
OR
http://tinyurl.com/d3u74

Cheers,

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com
 
M

maria pna

hi,
i would like you to provide me that step by step process.
another question: if i don't use yet wss, should i make backup of wss
database? (it's maybe a stupid question, but...)
thanks in advance
 
C

Chris Marriott

Hi Maria

Step by Step

This describes backing up a project server database for the first time to a
disk (please create an area that you would like to back the databases to
before starting


Open SQL Enterprise Manager

You will see Microsoft SQL Servers with an expand button to the left
Keep expanding the groups until you see Databases (open this group)
You will now see an entry for ProjectServer (this is the default but could
differ)
Highlight the ProjectServer entry and right click
Select all tasks and then Backup Database ...

At the top you can see the name of the database you are backing up
Select the backup type as Database - Complete
I am describing how to backup to disk but you can easily change this to the
tape options
Under destination click the Add button
I am working with filename to keep this simple - click the button with the
three dots
Browse to the location to save the project database and add a name for the
backup (no extension required)
Click ok
The backup is performed
If there had been a backup already in place you could have appended to the
backup or overwritten with the options below

Same process for the WSS and yes I would backup the WSS as of now as you are
creating sites even if you are not using them yet

Hope this helps some

--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer
 
S

Sara - EPM

Hi Rolly,

We have an issue with the other side of the coin, the restore portion.

A background on our situation:
1. 2 production machines, load balanced, with ProjectServer 2003 sp1 and
SharePoint sp2 installed.
2. 1 SQL database on a third machine that houses all the dbs.

We migrated the SQL dbs last week as we needed to decommission the old
server. Now, all is working except SharePoint. The night before the
migration, SP2 was applied to one of the production machines, therefore, when
we migrated and brought things back up, SharePoint saw two different versions
of service packs and didn't work anymore.

NOw, we have things back up, ProjectServer is all good; new content and
config databases were created. We have a backup of the old content/config.
We have moved table by table of content in an effort to restore the site. It
is not working.

How do you restore a site? It would be best to restore all the sites, but
we just really need one of the them.

THANKS!!!

Sara

Rolly Perreaux said:
hello
could anybody tell me how to do a backup - restore of project server ddbb
and WSS database?
thanks!
maria
Click to expand...


Hi Maria,

If you are just looking to backup the database, Chris has covered that.
But if you just want to backup a single Project Site (WSS) use the
STSADM.exe command with the BACKUP parameter on the WSS server.

Sample Syntax
stsadm.exe -o backup -url <url> -filename <filename> [-overwrite]

More info on STSADM.exe can be found at:
http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en
-us/stsk01.mspx
OR
http://tinyurl.com/d3u74

Cheers,

--
Rolly Perreaux, PMP
Project Server Trainer/Consultant

IT Summit Series
Advanced Microsoft Technology Training
http://www.itsummitseries.com
Click to expand...
 
Top