Restore ProjectServer_published

[nfo]

Hi,

I would like to restore ProjectServer_Published database using Sqlserver
Management Studio, but get the error message:
System.data.sqlClient.sqlerror: exlusive access could not be obtained
because the database is in use (microsoft.sqlservr.Smo)
Project server is running when I tried the restore.
I think I have to stop some applications or services but don't know which
ones

I'm using Sqlserver 2005 and Project server 2007

Many thanks for your help
Nfo

 

[Sander]

Hi,

If you need to restore this database for recovery, please be aware that you
have to restore the other databases to the same timestap too as these
database are depending on each other. To be able to get exclusive access, you
need to stop project server queueu and event services. Also the
webapplication where project server resides, needs to be stopped. In an
environment where IIS is only used for project server, i would stop IIS
completely.

hope this helps.
Sander

 

[nfo]

Hi Sander
Many thanks for your rapid response, It works fine.

Nfo