PS2007 - Restore Databases using SQL Server 2005

T

TroyS

I'm trying to restore databases from TestOne to TestTwo environments (long
story why we're having more than 1 test...)

When i try to restore the Published or Draft database using SQL Server 2005
Mgmt Studio, i get an error that the database is in use. However, no one is
logged into PWA.

When i look at who is logged in via SQL Server 2005 Mgmt Studio, I only see
the service accounts in the Project Server databases.

Do i need to turn off all Project Server Services before restoring? any help
or direction would be appreciated.

thx.
 
P

Paul Conroy

Quiesce the farm.

Stop the Project Queue and Eventing Services.

Detach the Project Server Databases, forcing the disconnection of any users.

Restore the DBs from backup.

Restart the services.
 
T

TroyS

Thanks Paul. I will try out...

Paul Conroy said:
Quiesce the farm.

Stop the Project Queue and Eventing Services.

Detach the Project Server Databases, forcing the disconnection of any users.

Restore the DBs from backup.

Restart the services.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Provisioning failed because the databases specified did not match 0
Restore Project Server 2007 Instance - Only SQL Backups 2
Moving Project Server 2007 instances 0
Can I Restore PWA Databases ? 0
Project Server 2007 SP2: Gantt with data in OLAP but not in Published or Draft Databases 0
Restore Project hangs at Getting Queued 3
Moving MOPS/WSS databases from SQL 2000 to SQL 2008 server 0
Restore Project Server Database using SQL Server Tools 2

Top