Project Server 2007 Backup

L

Limbo

Hello,

This may sound dumb but I am new to Project 2007 Server. Actually I am new
to Project Server in general. From what I've read in this discussion group
is to just backup the SQL databases and you are all set. I guess my question
is why does Project Server 2007 have an area to schedule backups and where
does it store the backups? I haven't seen anything anywhere that says where
it stores the backups. I'm just trying to cover all of the bases and make
sure I understand things correctly. I think at this point I am more curious
as to where it stores the backups.

Thank you,
 
B

Ben Howard

The backup bit actually stores the selected data in the Archive database,
which then allows you to restore, for example, a single project from the
archive DB and overwrite the project in the working store. Ther are hugh
process implications around this... However, for normal DR scenarios, backup
the SQL databases and you should be fine.
 
N

NZ Projects

You'd be better off backing up the WSS farm from central admin and not SQL.
This makes restore much easier to do.

You also need to backup the IIS Metadata (system state backup on 2003 server
does this), and file directories used by IIS.
 
A

Adnan

There are no. of benefits of taking backup from PWA website, which you
can't get even if you have database backups.
For example, Whenever you want to make any changes in Enterprise
Global data, as a best practice you should take backup, in case, you
have done something wrong and you have to restore only Enterprise
Global.
It is also a handy tool, for restoring single project, resource etc.
Still, you need to schedule full database backups either from
SharePoint Central Administration or SQL Server Management Studio as
you need it in case of disaster recovery.

Thanks

Adnan Ahmed
IW Solutions Consultant
Owner: http://www.projectservergurus.com
Blog: http://www.projectservergurus.com/adnan
 
N

NZ Projects

You can't schedule farm backups from central admin, you need to use Windows
task schedule to run the stsadm command to perform this function.
 
I

Ignbell

I`m new and i don´t want to sound lazy but could you post te command lines
you use to backup PS2007 with stsadm. i`d appreciate the example.

Thankyou
Nacio
 
Top