Backup and Restore Project Server 2007


This post comes to us courtesy of Mark Shea of our Office Assistance area.

Introduction

This post will guide you through the Microsoft Office Project Server 2007 backup and restore process by using the the SharePoint Central Administration Web site.

Set up a file share

If you do not already have a remote file share to store the backup files, you must set one up before backing up your environment.

Set up a remote file share

  1. (Recommended) Make sure SQL ‘Setup server account’ is using a domain account; see SQL Server books online on how to do it.
  2. Verify that the remote file share can be accessed from both the SQL Server computer and the computer that is hosting Central Administration.
  3. On the remote file server, create a directory and share it out. Be sure to give it access permissions for the account you will be using to backup and restore.
  4. On the Share Permissions tab of file share properties, grant the accounts listed below, Change and Read rights.
  5. On the Security tab of the file share Properties, grant the accounts listed below all the rights except Full Control.

Create required accounts

Accounts needed:

  • SQL server account (if “Local system” is the SQL service account, you must grant permission to the SQL server computer.).
  • Login account (required to do backup and restore using the command prompt).
  • The Windows SharePoint Services 3.0 front-end server account, such as <domain>\<server name>$ (required to do backup and restore using the user interface).
  • The central administrator pool account (required to do backup and restore using the user interface).
  • The Timer service account (requested by UI).

Note The central administrator pool and the Timer service use the same user account.

Note If you receive any errors during the backup or restore process, you must delete the failed “Backup/Restore” timer job before you can run the next backup or restore process. The URL for the Timer service jobs is:

http://<adminsite:port>/_admin/ServiceJobDefinitions.aspx.

Note You do not have to delete the Timer service job if you did the Project Server 2007 backup or restore by using the stsadm.exe command-line tool.

Note The server farm should be taken offline prior to backup.

Back up your environment

To back up your Project Server 2007 installation, do the following:

  1. Navigate to Central Administration; the URL looks like http://<server_name>:port/default.aspx.
  2. Click Operations on the top navigation bar.


  3. In the Backup and Restore section of the Operations page, click Perform a Backup.


  4. On the Select Component to Backup page, choose the components you want to back up, such as Farm or an individual site. You can select any one component and all components under it.


  5. When you have selected all the components you want to back up, click Start Backup Process.

    On the Start Backup page, under Backup File Location, enter the UNC path to the backup folder.


  6. Click OK
  7. You can view the backup job status on the backup status page, by clicking Refresh. The page will also refresh every 30 seconds automatically. Backup and Restore is a Timer service job, so it may take few seconds for the backup to start


  8. If you receive any errors, you can find more information by looking in spbackup.log at the UNC path you specified above

Restoring a Project Server 2007 deployment

This section guides you through the Microsoft Office Project Server 2007 restoration process using Central Administration. It describes how to restore over the original server farm. This document does not describe a migration of Project Server 2007 data.

Restore to the original farm
  1. Navigate to Central Administration; the URL looks like http://<server_name>:port/default.aspx.

     

  2. Operations on the top navigation bar.
  3. In the Backup and Restore section of the Operations page, click Restore from backup.


  4. On the Restore from Backup: Step 1: Select Backup File page, under Backup File Location, enter the UNC path to the backup folder.


  5. On the Restore from Backup: Step 2: Select Backup Package to Restore page, choose the target backup package and click Start Restore Process.


  6. On the Restore from Backup: Step 3: Select Component to Restore page, choose the restore level (Farm, Service, Database or SSP) and click Start Restore Process.


  7. On the Restore from Backup: Step 4: Select Restore Options page, select Overwrite (Create new is the default value) and click OK in the pop-up dialog.


  8. Under New Names, enter the user name and password for the Web applications listed on the page.


  9. Click OK.
Comments (43)

  1. Hi there,

    Thanks for this information – I had a quick go at this, but what I am not to sure about (and it was also not specified in the post), is exactly on which level you select components to backup and restore if you only want to backup or restore a Project Server installation.

    Do we need to select the whole sharepoint environmnent?

    Thanks

  2. MP says:

    Having had a go at restoring a 2007 system already I can tell you that all you need is the sharepoint content database as well as the project databases.  From this you can recover everything.

  3. Igor Macori says:

    Un buon articolo passo per passo (con tanto di screenshots) su come impostare il Backup e Restore su

  4. JSandstad says:

    Have set up a very low security share (everyone – change + read) NTFS set similarly on a File Server, initiated the backup but nothing started.

    Windows SharePoint Services Timer – Started (Domain Acc OK)

    Windows SharePoint Services VSS Writer – Manual (Local System)

    SQL Server VSS Writer – Manual (Local System)

    Attempted with stsadm.exe to same share.

    The backup stalls at:

    [2/2/2007 1:28:24 PM]: Verbose: Starting object: Windows SharePoint Services Help Search.

    [2/2/2007 1:28:25 PM]: Progress: [Windows SharePoint Services Help Search] 50 percent complete.

    [2/2/2007 1:28:25 PM]: Verbose: Starting object: Search instance.

    [2/2/2007 1:28:26 PM]: Progress: [Search instance] 50 percent complete.

    Any ideas why either of these would not work?

    Thanks

    Justin

  5. JSandstad says:

    Further to my last post…

    I’ve discovered there is a "Search Backup and Restore (pause) application ……" entry in the Timer Job Definitions.

    Schedule Type: One-Time

  6. Anirudh says:

    Hi,

    I have a question about restoring a Project Server site.

    I’ve got the backups of the Web application(content db and all) and the project Web access site(4 project dbs).

    Now in order to restore the same environment, do I need to restore the web application first and then follow it up with the project web access site?

    I ask this because on restore the Project webaccess site does not ask for any web application to restore under.

    Does it restore under a web application with the same name(port) as it was under before?

  7. sasho says:

    Hello Treb,

    Thank you for the clear and helpful article.

    I follow your step by step instructions to restore Project Server 2007 from my backup. The only difference is that I put the backup in a local folder.

    Then I uninstalled Office project server completely, also deleted all the data in the local database folder.

    Then I reinstalled Project Server again using basic setup. I ensured SQL server account have full permissions on the data files and started full restore from the backup folder.

    Unfortunately I received errors that some objects already exists no matter I choose override option.

    Why is that. Please help, what I miss ?

    Here is one sample error :

    —————————————————-

    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_1ac3f072-9b11-4c02-9586-67016efc0c24".  Rename your object or delete the existing object.

    ————————————————

    I also have the same for PWA feature also.

    These objects also never reach completed status. They stay on "Completing" forever.

    I’ll appreciate any information you can post.

    Thank you.

    Alexander Tzvetanov

  8. Ana says:

    Hi,

    Thank you for your article. I have a question about restoring a single project in project server 2007 ?

    Is there any substitute tool or procedure for the

    Restore Single Project Tool in Project 2003?

    Thank you in advance,

  9. This post has been long comming. I recently spent some time with Samer Sawaya of SharePoint Recycle bin

  10. Joe says:

    If I wanted to copy one PWA configuration to another. How do you backup and restore the databases to another PWA provisioned site.  These steps looks like good for 1 to 1 backup and restore procedures.

  11. sasho says:

    Dear Everybody,

    After I finally hadn’t succeeded to backup and restore MS Project server neither all Sharepoint nor only PWA using the above instructions. I called the trouble help me.

    Unfortunately this particular blog’s issuer also doesn’t help.

    So I finally ran filemon/regmon and setup the Basic configuration of PWA.

    As a result I made 2 .bat files for backup and restore of the basic configuration. In my case Windoes and also PWA was installed on drive D:. My backup folder is located at D:ProjectServerBackup.

    If any of you also have trouble with backup/restore MSProject server. Try my way.

    Regards

    Alexander Tzvetanov

    Follows the backup and restore scripts:

    backup.bat

    —————————-

    @ECHO **************************************************************************

    @ECHO * STOP ALL SERVICESS                                                     *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    @ECHO OFF

    SET BACKUP_PATH=D:ProjectServerBackup

    net stop "World Wide Web Publishing Service"

    net stop "Windows SharePoint Services Tracing"

    net stop "Windows SharePoint Services Timer"

    net stop "Windows SharePoint Services Search"

    net stop "Microsoft Office Project Server Events Service"

    net stop "Microsoft Office Project Server Queue Service"

    net stop "SQL Server (OFFICESERVERS)"

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * EXPORT REGISTRY KEYS                                                   *

    @ECHO *                                                                        *

    regedit /E %BACKUP_PATH%WebExt.reg "HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions12.0"

    regedit /E %BACKUP_PATH%Certs.reg "HKEY_LOCAL_MACHINESOFTWAREMicrosoftSystemCertificatesMyCertificates"

    copy "%WINDIR%system32inetsrvMetaBase.xml" "%BACKUP_PATH%MetaBase.xml" /Y

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * COPY FILES                                                             *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    xcopy "%SYSTEMDRIVE%Program FilesMicrosoft Office Servers*.*" %BACKUP_PATH% /S /F /Y /R

    md "%BACKUP_PATH%Application Data"

    md "%BACKUP_PATH%Application DataMicrosoft"

    md "%BACKUP_PATH%Application DataMicrosoftSharePoint"

    md "%BACKUP_PATH%Application DataMicrosoftSharePointConfig"

    xcopy "%SYSTEMDRIVE%Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig*.*" "%BACKUP_PATH%Application DataMicrosoftSharePointConfig" /S /F /Y /R

    xcopy "%SYSTEMDRIVE%Inetpubwwwrootwss*.*" %BACKUP_PATH% /S /F /Y /R

    md "%BACKUP_PATH%web server extensions"

    md "%BACKUP_PATH%web server extensions12"

    xcopy "%SYSTEMDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensions12*.*" "%BACKUP_PATH%web server extensions12" /S /F /Y /R

    md "%BACKUP_PATH%web server extensionswpresources"

    xcopy "%SYSTEMDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensionswpresources*.*" "%BACKUP_PATH%web server extensionswpresources" /S /F /Y /R

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * START ALL SERVICESS                                                    *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    net start "SQL Server (OFFICESERVERS)"

    net start "Windows SharePoint Services Tracing"

    net start "Windows SharePoint Services Timer"

    net start "Windows SharePoint Services Search"

    net start "Microsoft Office Project Server Events Service"

    net start "Microsoft Office Project Server Queue Service"

    net start "World Wide Web Publishing Service"

    restore.bat

    ———————————————–

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * STOP ALL SERVICESS                                                     *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    @ECHO OFF

    SET BACKUP_PATH=D:ProjectServerBackup

    net stop "World Wide Web Publishing Service"

    net stop "HTTP SSL"

    net stop "IIS Admin Service"

    net stop "Windows SharePoint Services Tracing"

    net stop "Windows SharePoint Services Timer"

    net stop "Windows SharePoint Services Search"

    net stop "Microsoft Office Project Server Events Service"

    net stop "Microsoft Office Project Server Queue Service"

    net stop "SQL Server (OFFICESERVERS)"

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * COPY FILES                                                             *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    del "%WINDRIVE%Program FilesMicrosoft Office Servers12.0" /Q /S /F

    rd "%WINDRIVE%Program FilesMicrosoft Office Servers12.0" /S /Q

    md "%WINDRIVE%Program FilesMicrosoft Office Servers12.0"

    xcopy %BACKUP_PATH%12.0*.* "%WINDRIVE%Program FilesMicrosoft Office Servers12.0" /S /F /Y /R

    del "%WINDRIVE%Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig" /Q /S /F

    rd "%WINDRIVE%Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig" /Q /S

    md "%WINDRIVE%Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig"

    xcopy "%BACKUP_PATH%Application DataMicrosoftSharePointConfig*.*" "%WINDRIVE%Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig" /S /F /Y /R

    del "%WINDRIVE%InetpubwwwrootwssVirtualDirectories" /Q /S /F

    rd "%WINDRIVE%InetpubwwwrootwssVirtualDirectories" /Q /S

    md "%WINDRIVE%InetpubwwwrootwssVirtualDirectories"

    xcopy %BACKUP_PATH%VirtualDirectories*.* "%WINDRIVE%InetpubwwwrootwssVirtualDirectories" /S /F /Y /R

    del "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensions12" /Q /S /F

    rd "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensions12" /Q /S

    md "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensions12"

    xcopy "%BACKUP_PATH%web server extensions12*.*" "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensions12" /S /F /Y /R

    del "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensionswpresources" /Q /S /F

    rd "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensionswpresources" /Q /S

    md "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensionswpresources"

    xcopy "%BACKUP_PATH%web server extensionswpresources*.*" "%WINDRIVE%Program FilesCommon FilesMicrosoft Sharedweb server extensionswpresources" /S /F /Y /R

    @ECHO Please setup registry and restore WEB environment

    regedit /D /S "HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsWeb Server Extensions12.0"

    regedit /C /S %BACKUP_PATH%WebExt.reg

    @REM regedit /D "HKEY_LOCAL_MACHINESOFTWAREMicrosoftSystemCertificatesMyCertificates"

    regedit /C /S %BACKUP_PATH%Certs.reg

    copy "%BACKUP_PATH%MetaBase.xml" "%WINDIR%system32inetsrvMetaBase.xml" /Y

    @ECHO **************************************************************************

    @ECHO *                                                                        *

    @ECHO * START ALL SERVICESS                                                    *

    @ECHO *                                                                        *

    @ECHO **************************************************************************

    net start "SQL Server (OFFICESERVERS)"

    net start "Windows SharePoint Services Tracing"

    net start "Windows SharePoint Services Timer"

    net start "Windows SharePoint Services Search"

    net start "Microsoft Office Project Server Events Service"

    net start "Microsoft Office Project Server Queue Service"

    net start "HTTP SSL"

    net start "IIS Admin Service"

    net start "World Wide Web Publishing Service"

  12. Pedro Medina says:

    hi there:

    I have two error during the restore.

    The backup of a single site don´t have problems.

    When I did the restore in a new stand alone Server, I have two error:

    Error 1: Object My site failed in event OnRestore. For more information, see the error log located in the backup

    directory.

    ArgumentException: The IIS Web Site you have selected is in use by SharePoint.

    You must select another port or hostname.

    Error 2: Object EDF_DB failed in event OnRestore.

    SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005,

    this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

    (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)

    Can Anybody help me?

    regards

  13. Shraddha Shah says:

    Pedro Medina where you able to find the solution for your problem mentioned above as i am having the same issue

    Thanks,

    Shraddha

  14. Varun says:

    Dear All,

    i m Varun and i m working in a Private firm. i have to make ready project server but i dont have any idea bout that. any one of yall can mail me the installation steps of MSP 2007 Server and Professional. also if possible can yall mail me how to connect MSP Client with the MSP Server.

    yall help will be very kindful. Pls mail the documents on this ID: varun.palija@kalpataru.com

    regards

    Varun.

  15. alen martynov says:

    hi all

    i have already backed up my PWA sites successfully, using way interoduced above, but i have one problem, i cant restore my back up in another SSP!

    please help on this issue

    my email is alen.martynov@gmail.com

  16. venu says:

    Thanks it was great piece of info very easy steps but one doubt i still could not complete my backup it still saya that the cannot open back up device access deined

  17. Gordon says:

    I am baffed witht the following situation and run completely out of ideas. I am trying to Backup a Project Server 2007 installation (complete Farm) but the backup process keeps failing with the following error.

    Cannot open backup device &#39;\vupsdb01ProjectServerBackupsspbr00000000017.bak&#39;. Operating system error 5(error not found). BACKUP DATABASE is terminating abnormally.

    The installation is a small farm with Application Server and Database Server on seperate boxes.

    I have created a file share and given the logged in account, App Pool Account and DB Account secutiy and sharing rights to create/modify.

    I can access the file share from both computers. What baffles me is that the back up logs are written in the file share but it errors out.

    Any pointers much appreciated

  18. abdul says:

    hi i just wanna to clarify that how the tender procedure test in windows sharepoint service and how can make workflow for tender procedure…. please clear my doubt

         thank you  

  19. Dmitry says:

    How can I move all the data from one share point farm server to another server farm the way it resemles the old data structure, site collections, PWA etc?

    Thank you for any info…  

  20. Terry says:

    has anyone tried a standalone restore to another sharepoint server and had it work? If so PLEASE let me know how you did it!!

    TJ

  21. Alex Alba says:

    Do you know how make a Enterprise Global Backup?

  22. Worrier Princess says:

    Does anyone know how to create a scripted backup for all of the front end sites so that you can restore them individually?  I have a site backup script for my Sharepoint 2007 server but I can’t get it working for Project 2007.

  23. Bruno Velaz says:

    I was restore of backup de MOSS, but occurs the restore error. SPDuplicateObjectExceptio

    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_1ac3f072-9b11-4c02-9586-67016efc0c24".  Rename your object or delete the existing object

    Whats I’m making wrong??

  24. mv griffith says:

    I am looking for information on migrating from Project Server 2003 to 2007 with MS Project Portfolio Server.  I am interested in a project plan or even some ideas on how to proceed.

  25. cesar cruz says:

    I read all the above issues but not one answer to any of them. Am I missing something here?

  26. Aparna says:

    The instructions in this article are very clear. I was able to backup and restore sucessfully using the Central Admin. The job status screen showed ‘Complete’ without any errors. But when I access the pwa site it gives me a ‘File not found exception’ I have lloked at the PWA folder and all the files do not exist. I can access the subsites and by going to Top level sites I can still go to the main PWA site settings.

    –Any pointers on why I am getting the file not found error.

    Thanks in advance.

  27. Surender Verma says:

    Hi Everyone

    I have schedule a backup script for full firm backup using stsadm.exe but last night I found backup is not complete it stops at a point log are as follows..

    [4/1/2008 9:38:59 PM]: Verbose: [PWA_Reporting_D09659B6_36A0_4D3B_9FB8_F0F261F171D1] SQL command completed at: 4/1/2008 9:38:59 PM.

    [4/1/2008 9:38:59 PM]: Verbose: Starting object: UserProfileApplication.

    [4/1/2008 9:38:59 PM]: Progress: [UserProfileApplication] 50 percent complete.

    [4/1/2008 9:39:00 PM]: Verbose: Starting object: SessionStateSharedApplication.

    [4/1/2008 9:39:00 PM]: Verbose: Starting object: Shared Search Index.

    [4/1/2008 9:39:00 PM]: Progress: [Shared Search Index] 50 percent complete.

    please help me resolving this issue

    Thanks in advance

  28. ArchBlogger says:

    The error below coincides with moving the project, sharepoint and portfolio server databases from the SQL server’s C: drive to the D: drive.

    Event Type:     Error

    Event Source:   Office SharePoint Server

    Event Category: Office Server General

    Event ID:  7888

    Computer Name: Node1

    Description:

    A runtime exception was detected. Details follow.

    Message: Cannot open database "WSS_PWAContent" requested by the login. The login failed.

    Login failed for user ‘ABCCOMPNETsSharepointAdmin’.

    Techinal Details:

    System.Data.SqlClient.SqlException: Cannot open database "WSS_PWAContent" requested by the login. The login failed.

    Login failed for user ‘ABCCOMPNETsSharepointAdmin’.

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

      at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

      at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

      at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

      at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

      at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

      at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

      at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

      at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

      at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

      at System.Data.SqlClient.SqlConnection.Open()

      at Microsoft.Office.Server.Data.SqlSession.OpenConnection()

      at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)

      at Microsoft.Office.Server.Data.SqlDatabaseManager.HasAccess(String user)

      at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity)

      at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Synchronize()

  29. ArchBlogger says:

    The error below coincides with moving the project, sharepoint and portfolio server databases from the SQL server’s C: drive to the D: drive.

    Event Type:     Error

    Event Source:   Office SharePoint Server

    Event Category: Office Server General

    Event ID:  7888

    Computer Name: Node1

    Description:

    A runtime exception was detected. Details follow.

    Message: Cannot open database "WSS_PWAContent" requested by the login. The login failed.

    Login failed for user ‘ABCCOMPNETsSharepointAdmin’.

    Techinal Details:

    System.Data.SqlClient.SqlException: Cannot open database "WSS_PWAContent" requested by the login. The login failed.

    Login failed for user ‘ABCCOMPNETsSharepointAdmin’.

      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

      at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

      at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

      at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

      at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

      at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

      at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

      at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

      at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

      at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

      at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

      at System.Data.SqlClient.SqlConnection.Open()

      at Microsoft.Office.Server.Data.SqlSession.OpenConnection()

      at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)

      at Microsoft.Office.Server.Data.SqlDatabaseManager.HasAccess(String user)

      at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeAccessControl(SharedComponentSecurity sharedApplicationSecurity)

      at Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedComponent.Synchronize()

    Any help with this would be much appreciated.  

    -ArchBlogger

  30. Este semestre inicie a trabajar como arquitecto en nuevo proyecto de software y como herramientas de

  31. Este semestre inicie a trabajar como arquitecto en nuevo proyecto de software y como herramientas de

  32. Waqas Sarwar says:

    Hi Project server Gurus:

    I had a little problem in project server 2007 itemized Backuo schedule, We are using Project server 2007 and its web Access.

    When i use this option "Back up data automatically by using a daily schedule"

    On the Quick Launch, click Server Settings >Server Settings page, click Schedule Backup >Daily Backup Schedule page,  

    But the problem is that whatever time i set the daily backup its not worked. i dont know why?

    Could you please help me in this regard

  33. waqas105 says:

    Hi I am wondering if you will be give me someuseful resource reagrding the item level backup in Project Server Web access.

    I am using it but its not proerply. i schedule it on the server settings page under the schedule back up but at that time, now job is ruuning, no queue…..

    so pleasse help me in this regards.

  34. goutam says:

    The above process not work with sql expression edition.

    What is the process?

  35. waqas105 says:

    Hello

    I am performing the full farm restore on another server farm which is identical with the exisitng the prodcution envirnoment(1 APP, 1 Backend Database).

    I take the backup from production server and then move files over the development server.

    then i run the Sharepoint prodcut & technology wizards and dissconnect the server from farm,

    Again run the Sharepoint prodcut & Technology wizard and create a new Server Farm, with providing the details e.g Databse server, Content Db name, User name, password. user is domain admin

    then run the restore operation from central admin

    its run sucesfully

    now i go to the SSP page then on the PWA site and here it showed the error message infront of PWA URL, Failed see even log .

    i am wondering, whats wrong with it. Please help me.

  36. I will be going deeper in this posting, particularly on the scenario of moving just the databases and

  37. velmurugan says:

    Hi

    I have perform backup using above the screen shots.but it’s coming below the error.

    Directory \computername.domain.comBackup does not exist or the SQL Server service account and the ESERVICESAdministrator service account do not have permission to read or write to the backup folder. Specify a different directory.

    please help me.

  38. velmurugan says:

    i was perform backup successfully.afterthat i perform restore it showing below the error

    Object WSS_Search_ESPROD failed in event OnRestore. For more information, see the error log located in the backup directory.

    ESPROD means computername.

    this is happening before one month.

    Now i was run backup successfully.but restore option button is not available.please help me

  39. Ronak says:

    hello Friends,

    How to archive Project after completion form Project server 2007. when i archive project Actual work and planned both saved and when i restored this project next time it will show me as it is.

    Please find me some solution.

    Thanks

    Ronak

  40. Parag Kharche says:

    I am trying to Backup a Project Server 2007 installation (complete Farm) but the backup process keeps failing with the following error.

    as well as on restore i got the same error

    Object sharepoint_config failed in event on restore

    Cannot open backup device &#39;\vupsdb01ProjectServerBackupsspbr00000000017.bak&#39;. Operating system error 3(error not found). BACKUP DATABASE is terminating abnormally.

    The installation is a small farm with Application Server and Database Server on seperate boxes.

    I have created a file share and given the logged in account, App Pool Account and DB Account security and sharing rights to create/modify.

    I can access the file share from both computers. What baffles me is that when i create new site contents are written to database but on restore no contents are written to database………Plz reply…….

  41. joeproject says:

    Backup and restore is obviously a very weak area of Project Server.  I know that the Project Server team wants us to avoid getting into the databases, but some transparency into what happens during database creation might be helpful (ie, what happens during the WSS synchronization timer job, what changes in the config database, etc).  It’s great that the hotfixes are addressing custom field title properties and timephased actual work, but shouldn’t backup and restore be priority #1?  

  42. Rocco Castellano says:

    Question.  How can I set up recurring Backups to auto run?

    Thank you.

    Rocco

  43. Heather O'Cull says:

    Rocco – check out this article – support.microsoft.com/…/323330