Restore Project Server Database using SQL Server Tools

[Rafael Mascarenhas]

Hi all,

I'm trying to restore the 4 Project Server databases
(ProjectServer_Published, ProjectServer_Draft, ProjectServer_Archive and
ProjectServer_Reporting), using SQL Server Tools, I know that this isn't the
recommended approach but the back up I want to restore was made using SQL.

When I try to restore the ProjectServer_Draft database I get the following
error message: System.Data.SqlClient.SqlError: Exclusive access could not be
obtained because the database is in use.

According to this post on Technet
http://technet.microsoft.com/en-us/library/cc766553.aspx the only service I
need to stop before restoring the bases is the Windows SharePoint Services
Timer.

Do you guys have any ideas what other service needs to be stopped or what
else need to be done?

Thanks in advance,

Rafael Mascarenhas

 

[Gary L. Chefetz]

Rafael

I almost don't want to respond because of the dangerous territory you are
entering. You'll need to quiesce the farm and take the database offline to
do this as the SSP account, among others, has an active connection to the
database while the system is running.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Ben Howard]

Also worth checking Brian Smith's blog on this, he has some details, and
there are some on Technet/MSDN too.