Disaster Recovery Scenario for Project Server 2007

[luai7]

I know that this topic has been touched upon in one way or another in this
forum and in other sites. However, to be honest, until now, I did not find a
satisfying answer to what I am looking for, that's why I am reformulating the
questions in order to get a brief wrapping up on this issue from experts.

First of all from what I read and understood it is fully sufficient to have
an up-to-date backup of Project Server 2007 SQL Server databases in order to
be able to recover from a crash scenario. These databases are:

- ProjectServer_Archive
- ProjectServer_Draft
- ProjectServer_Published
- ProjectServer_Reporting

Is that all? Or do I have to have backup of the share point databases as
well? If yes, then which databases?

If the above scenario is valid, then how can I resore Project Server 2007 in
a machine-crash scenario: Assuming we reinstalled Windows 2003, and SQL
Server 2005 and we restored the backed up Project Server databases.... What's
next??

Thanks

 

[Nicky Ang]

Actually I do have the same concerns. We're so afraid that we're unable to
get our Project Server back to business.

Therefore we've hosted Project Server via Virtual Server and we backup the
whole image everyday. If main machine crashes, we just restore the whole
image and we're back in business. I'm quite sure this way, we can get back
100% fidelity.

 

[Bud Ratliff [MVP]]

Hi Luai7,

There are actually nine databases for a Project Server implementation,
including the Sharepoint Central Administration and Project Workspace sites.
I would highly recommend using the Perform A Backup command in the Central
Administrator/Operations page.

See this article from Mark Shea that describes how to backup your PS2K7
system
http://blogs.msdn.com/project/archive/2006/12/08/backup-and-restore-project-server-2007.aspx

and this article from Brian Smith that describes some of the challenges you
will face restoring to a "different" machine.
http://blogs.msdn.com/brismith/archive/2007/10/24/backup-and-restore-what-are-the-options.aspx

HTH,

 

[luai7]

Hi Bud,

How can you automate this backup? Because we need to have an automated
nightly backup at around 03:00

Thanks

 

[Nico Oosthuysen]

Hi,

I developed a little methodology for scheduling and deleting backups using
batch files and Windows Scheduled Tasks.

 

[luai7]

Hi Nico,

Where can we find these batches?

Thanks

 

[OK]

"C:\Program Files\Common Files\Microsoft Shared\web server
extensions\12\BIN\STSADM.EXE" -o backup -directory
\\servername\backupsharefolder -backupmethod full

 

[TheWall]

I run my scheduled backups the same as Nico via a script. You can also make
diffirential backups by changing the full to dif (i think, off the top of my
head)

It has also been recommended by a Moss 2k7 specialist to run exports which
can also be done via a scrip.