RE: Restore Project Plan to Project Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Karl Kill (anonymous_at_discussions.microsoft.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 11:41:07 -0800

 Thanks for the reply. I probably should make my question clearer. Is there anyway to select a single project from the backup medium and saving it to the 'real' database without first restoring the entire database to a temporary database?
     ----- anonymous@discussions.microsoft.com wrote: -----
     
     Hi
     I have done this before by opening the plan via ODBC link
     to the restored database, saving it locally and then
     saving it onto the 'real' database after deleting the old
     plan. This seemed to work OK
     
     
>-----Original Message-----
>We are using MS Project 2002 and one of my users' project
     needed to be restored from a backup. Our tech support
     takes the Production backup and restores the full database
     to our Test Project Server than pulls off this single
     project. Unfortunately, all test changes are wiped out.
>>My question, is there a way to restore a single project
     without overlaying the entire Test databases. This
     overlay wipes out all project and web tables including the
     enterprise global.
>>Thanks,
>Karl
>.
>

Relevant Pages

  • Re: company web user deleted doc
    ... backup exec and the back up ran over the weekend. ... the SQL databases do not get backed up unless you select the ... Those are stored in the MSDE database. ... see Backing Up and Restoring ...
    (microsoft.public.windows.server.sbs)
  • Re: Strategy for backup and restore
    ... > while restoring) cannot do. ... please do your self a favour and correctly backup databases using SQL Server ... that's to say BACKUP DATABASE ...
    (microsoft.public.sqlserver.msde)
  • Re: Potentially corrupt VSS 6.0 database
    ... and are now restoring from our daily ... backup of VSS. ... Is there anything I can do to restore the database? ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: VSS database not opening
    ... Can your restore the two files from a backup? ... database, although if analyze.exe says that files are corrupt, then the ... Apart from restoring a version of those files that works, ... > Admin privileges the first time, but later when I close this, ...
    (microsoft.public.vstudio.sourcesafe)
  • Re: Saving Database as different name
    ... the SaveAs command you get in Word or Excle is not available for saving the ... whole database. ... You can make a backup using Tools | Database Utilities | Back up ...
    (microsoft.public.access.gettingstarted)