Restore databade in project server 2007
-
Wednesday, May 02, 2012 3:13 PM
Hi everyone,
I am facing problem when restore farm backup in application server give some error like-
Object WSS_Content failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000026.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
4:38 PM Object SharedServices2_DB failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000027.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
Project Server Application Completing restore 5/2/2012 4:38 PM Object Project Server Application failed in event OnPostRestore. For more information, see the error log located in the backup directory. InvalidOperationException: ProjectPSISharedApplication.OnPostRestore
PWA Completing restore 5/2/2012 4:39 PM Object PWA failed in event OnPostRestore. For more information, see the error log located in the backup directory. InvalidOperationException: ProjectSite.OnPostRestore
ProjectServer_Published 5/2/2012 4:38 PM Object ProjectServer_Published failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000028.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Draft 5/2/2012 4:38 PM Object ProjectServer_Draft failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000029.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Archive 5/2/2012 4:38 PM Object ProjectServer_Archive failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\0000002A.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Reporting 5/2/2012 4:38 PM Object ProjectServer_Reporting failed in event OnRestore. For more information, see the error log located in the backup directory. SPException: The specified component exists. You must specify a name that does not exist.
Transformation Completing restore 5/2/2012 4:40 PM Object Transformation failed in event OnPostRestore. For more information, see the error log located in the backup directory. InvalidOperationException: ProjectSite.OnPostRestore
ProjectServer_Published_t 5/2/2012 4:38 PM Object ProjectServer_Published_t failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\0000002C.bak'. Opersystem error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Draft_t 5/2/2012 4:38 PM Object ProjectServer_Draft_t failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\0000002D.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Archive_t 5/2/2012 4:38 PM Object ProjectServer_Archive_t failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\0000002E.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Reporting_t 5/2/2012 4:38 PM Object ProjectServer_Reporting_t failed in event OnRestore. For more information, see the error log located in the backup directory. SPException: The specified component exists. You must specify a name that does not exist.
RollOut Completing restore 5/2/2012 4:40 PM Object RollOut failed in event OnPostRestore. For more information, see the error log located in the backup directory. InvalidOperationException: ProjectSite.OnPostRestore
ProjectServer_Published_RO 5/2/2012 4:38 PM Object ProjectServer_Published_RO failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000030.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Draft_RO 5/2/2012 4:38 PM Object ProjectServer_Draft_RO failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000031.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Archive_RO 5/2/2012 4:38 PM Object ProjectServer_Archive_RO failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000032.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Reporting_RO 5/2/2012 4:38 PM Object ProjectServer_Reporting_RO failed in event OnRestore. For more information, see the error log located in the backup directory. SPException: The specified component exists. You must specify a name that does not exist.
Transformation Completing restore 5/2/2012 4:40 PM Object Transformation failed in event OnPostRestore. For more information, see the error log located in the backup directory. InvalidOperationException: ProjectSite.OnPostRestore
ProjectServer_Published_nw 5/2/2012 4:38 PM Object ProjectServer_Published_nw failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException:
Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000034.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Draft_nw 5/2/2012 4:38 PM Object ProjectServer_Draft_nw failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000035.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Archive_nw 5/2/2012 4:38 PM Object ProjectServer_Archive_nw failed in event OnRestore. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device 'D:\Backup-18-10-10-FPB\spbr0018\00000036.bak'. Operating system error 3(The system cannot find the path specified.). RESTORE DATABASE is terminating abnormally.
ProjectServer_Reporting_nw 5/2/2012 4:38 PM Object ProjectServer_Reporting_nw failed in event OnRestore. For more information, see the error log located in the backup directory. SPException: The specified component exists. You must specify a name that does not exist.
SessionStateSharedApplication Completing restore 5/2/2012 4:38 PM Object SessionStateSharedApplication failed in event OnPostRestore. For more information, see the error log located in the backup directory. NullReferenceException: Object reference not set to an instance of an object.
How to resolve it...
Please help me...
Neeraj
All Replies
-
Wednesday, May 02, 2012 3:51 PM
Hello Neeraj,
Please check the permissions on the directory where farm backup is stored. If needed assign full control to everyone on file level as well as share permission level
Hrishi Deshpande – DeltaBahn Senior Consultant
Blog | < | LinkedIn- Proposed As Answer by Laksh Rao Thursday, May 03, 2012 1:44 AM
-
Thursday, May 03, 2012 1:44 AM
Hi Neeraj,
Atleast the following is required if your security policy does not allow full control to Everyone.
The SQL account, the timer service account, and the Central Admin pool account must have read permissions to the backup locations. You need to be CA Administrator.
Thanks,
Laksh