none
All past days we have been creating handy database in project RRS feed

  • Question


  • Only two days ago we finished it, our department created quite great thing for all our company. Yesterday it bugged and all our data fell down. We used microsoft mpp recovery tool from Microsoft, but we could get back only 1/3 of data. Some employers can work with data, other can't. We are out of ideas... Our version of MS Project is 2010.

    Tuesday, July 17, 2018 3:48 PM

All replies

  • Can you be more specific about what happened. "It bugged" doesn't really help us to help you :-)
    Wednesday, July 18, 2018 9:02 AM

  • Only two days ago we finished it, our department created quite great thing for all our company. Yesterday it bugged and all our data fell down. We used microsoft mpp recovery tool from Microsoft, but we could get back only 1/3 of data. Some employers can work with data, other can't. We are out of ideas... Our version of MS Project is 2010.

    To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. After you restore the database, you must delete and then re-create the MSProjectServerUser and MSProjectUser accounts to make sure that the correct passwords are configured. To do this, follow these steps:

    1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
    2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft Project Server database server, and then expandDatabases.
    3. Right-click the Microsoft Project Server database, point to All Tasks, and then click Restore Database.
    4. From the list of backups, click the backup to restore, and then click OK to start the restore.
    5. Click OK to confirm that the restore completed successfully.

    To delete and re-create the database users, follow these steps:

    https://support.office.com/en-us/article/File-formats-supported-by-Microsoft-Office-Project-053a3fc8-5671-4ed9-a2e4-6269e2f26de1

    https://support.microsoft.com/en-us/help/323330/how-to-back-up--schedule--and-restore-a-microsoft-project-server-datab

    https://onlinefile.repair/en/project.html

    1. Expand your restored Project Server database.
    2. Click Users, and then click the MSProjectServerUser user.
    3. Press DELETE, and then click Yes to confirm the deletion.
    4. Click MSProjectUser, and then press DELETE.
    5. Click Yes to confirm the deletion.
    6. Right-click Users, and then click New Database User.
    7. Under Login name, click MSProjectServerUser, and then under Database role membership select MSProjectServerRole.
    8. Click OK.
    9. Right-click Users, and then click New Database User.
    10. Under Login name, click MSProjectUser, and then under Database role membership select MSProjectRole.
    11. Click OK.
    12. Log on to Microsoft Project Web Access to verify the connection.
    Monday, July 23, 2018 3:33 PM