Backup and restore

[BudOlly]

Hello,

I am trying to create a backup routine for our project 2007 server for
disaster recovery. I've read the technet articles on how to use stsadm to
backup the farm and site collections, but the problem I'm having is that I
cannot seem to successfully restore a farm onto a newly built server even
though it uses the same specs, config, names, etc. I'm testing this out with
Suns virtual box, and it works fine if I restore to the same farm. If I tear
it down and rebuild it, stsadm fails to restore the SSP and PWA.

Does stsadm ONLY restore to the same farm, or can I somehow rebuild a
different farm that I can restore to? Is it better to just use SQL's backup
tools to backup the DBs?

 

[Ben Howard]

Hi BudOlly,
You need to use the STSADM tool if you want to restore the whole lot
(content db, search db, project dbs etc) and tie them all together. I've
only done this in a limited testing environment, but I would run the
sharepoint technology config wizard to create a new farm (same name as the
other), and once this is created, use stsadm to restore the farm settings...
Is this what you are doing? You'll need the SSP created too, but no PS
instances...

 

[BudOlly]

Ben Howard,

Thank you for your quick response. Yes, I have been using stsadm to backup
the entire farm. Then, using my test environment, I will create a farm with
same specs, service packs and so forth and try to restore to this using
stsadm. I have been consistently getting the following errors:

Error: Object SharedServices1 failed in event OnRestore. For more
information, see the error log located in the backup directory.
SPDuplicateObjectException: An object of the type
Microsoft.Office.Server.Administration.SharedResourceProvider named
"SharedServices1" already exists under the parent
Microsoft.SharePoint.Administration.SPFarm named
"SharePoint_Config_64c4e36e-8fe9-42ae-9376-af36a0f43de6". Rename your object
or delete the existing object.

Error: Object WSS_Content failed in event OnPostRestore. For more
information, see the error log located in the backup directory.
SqlException: Database state cannot be changed while other users are using
the database 'WSS_Content'
ALTER DATABASE statement failed.
sp_dboption command failed.

Error: Object Project Server Application failed in event OnPostRestore. For
more information, see the error log located in the backup directory.
SqlException: The INSERT statement conflicted with the FOREIGN KEY
constraint "FK_Dependencies1_Objects". The conflict occurred in database
"SharePoint_Config_64c4e36e-8fe9-42ae-9376-af36a0f43de6", table
"dbbjects", column 'Id'.
The statement has been terminated.

Error: Object pwa failed in event OnPostRestore. For more information, see
the error log located in the backup directory.
InvalidOperationException: Operation is not valid due to the current state
of the object.

When you say I should not have a PS instance, are you talking about the PWA
site itself?

 

[Ben Howard]

Indeed, no PS instance means no PWA site itself. IMHO Sharepoint errors and
restores are a night mare to troubleshoot. Worth looking at the sharepoint
blogs...
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Toufiq]

Hi Ben,

I need some help in troubleshooting the below two errors, let me tell you
the scenario...

we have a production MOSS running with PWA... we want to migrate only the
PWA... I have installed MOSS and provision the new PWA... have taken a backup
of PWA databases i.e. ProjectServer_Published03,ProjectServer_Draft03,
ProjectServer_Archive03 and ProjectServer_Reporting03.

Now when I'm restoring through Central Administration getting these below
mentioned errors. Your help will much appriaciated...

Project Server Application Completing restore 11/4/2009 9:49 PM Object
Project Server Application failed in event OnPostRestore. For more
information, see the error log located in the backup directory.
FileNotFoundException: The site with the id
7d16954f-1114-4054-9738-b32aa88511ee could not be found.

PWA Completing restore 11/4/2009 9:50 PM Object PWA failed in event
OnPostRestore. For more information, see the error log located in the backup
directory. InvalidOperationException: ProjectSite.OnPostRestore

thanks,
Toufiq.