locked
2007 Project Server -- get an older version of a document from a Project Workspace RRS feed

  • Question

  • I have a user that is trying to retrieve an older version of a document that was on one of the Project Workspaces.  This was the only version of the document so I am trying to retrieve it.  The document was not deleted but just overwritten by a newer version of the file.  I have a full SQL backup of the of all the database required for PWA prior to the file being overwritten.  What all do I need to do to get the file from the SQL backups?  Since the file was in a Workspace, do I have to restore everything to a seperate instance of Project Server or is it possible to restore the backups to just a seperate instance of SharePoint?  What are the steps I need to go through to restore the Workspace to retrieve the file? Do I have to restore all the databases?  Any help will be greatly appreciated.  Thanks.
    Monday, January 31, 2011 5:15 PM

Answers

  • You can restore the content DB and retrieve the desired site along with content

    Create anew Web App >> Via CA >> Content Db >> remove the content Db, attach the old content DB(of course restored on Sql already)  using stsadm command line tool

    Stsadm -o addcontentdb -url <URL name> -databasename <database name>

    Hope this helps


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Monday, January 31, 2011 6:42 PM

All replies

  • You can restore the content DB and retrieve the desired site along with content

    Create anew Web App >> Via CA >> Content Db >> remove the content Db, attach the old content DB(of course restored on Sql already)  using stsadm command line tool

    Stsadm -o addcontentdb -url <URL name> -databasename <database name>

    Hope this helps


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Monday, January 31, 2011 6:42 PM
  • Hi,

    In the future you may want to look at turning on version history within the document library so that if a file is overwritten you have a copy saved inside the workspace and the user can simply restore it, rather than needing to restore a full contentdb. 

    Regards,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Monday, January 31, 2011 6:52 PM
  • When I create the new Web App, does it have to be on an existing instance of a Project Server or can I also perform these same steps on just a test SharePoint server?  Since it was for Project Web Access I was not sure if things would connect correctly.  Thanks for all your help.
    Monday, January 31, 2011 7:22 PM
  • yes you can do it on any instance :) be it test or prod, you just need a new web app, its almost like migrating an existing content DB from dev to Prod ( in your case would be opposite from Prod to dev)
    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Monday, January 31, 2011 7:29 PM