Urgent / Database deleted

S

Sittania

I accidentally deleted the Project server database!!! Then
I tried to restores it form the Recycle bin but it didnt
go back. I have made backups but I get these error
messages when I try to restore:


The Volume on Drive C:\SQL backup\backup is not a part of
media family set. Backup with format can be used to form a
new media set.

Restore is terminated abnormally.

OR:

There is a logic device associated to the disk file name
you just selected. Please select the logic device instead
or specify a new disk file name.

Does anybody know what I need to do?

Thanks,
NC
 
M

Mark Bortis[MSFT]

Please try the following:
Restoring the Database

To restore the Project Server database, you can use the restore feature of Microsoft SQL Server. After you restore the database, you must
delete and then re-create the MSProjectServerUser and MSProjectUser accounts to make sure that the correct passwords are configured. To
do this, follow these steps:
Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft Project Server database server, and then expand
Databases.
Right-click the Microsoft Project Server database, point to All Tasks, and then click Restore Database.
From the list of backups, click the backup to restore, and then click OK to start the restore.
Click OK to confirm that the restore completed successfully.

The whole article can be found at:
PSRV2002: How to Back Up, Schedule, and Restore a Microsoft Project Server Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;323330

Please reply to this news thread to let me know if it helped or not.
--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they
originated.
 

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

Top