HELP.Restoring Database.

[herngyih]

Hello all,

I had deployed project server in a new machine.All went smooth until the
restoring part.I would want the new project server to have all the data in
the previous project server.Including those users and projects.

What I did:
1.Install Project Server normally.I didnt chose connect to the existing
databse.I chose "create a new database".

2.Of course the new server name is different with the old one.

3.I force restore on database created during the new installation with the
new database in SQL Enterprise Manager.With the hope that everyting run
smooth and i will have a project server just like the old one.

4.Well,it didnt happen.I cant even access with administrator login.Bunch of
error pop up when i click on those tables in Enterprise Manager.

My Questions:
1.Did i did the procedure correctly?Restoring a data like that?
2.Any solution?Workaround?
2.Other ways?

Thank You so much,Need ur guy`s help urgently.

 

[Ray McCoppin]

Herngyih: try these steps:

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:1. Click Start, point to Programs, point to Microsoft SQL Server, and
then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your
Microsoft Project Server database server, and then expand Databases.
3. Right-click the Microsoft Project Server database, point to All Tasks,
and then click Restore Database.
4. From the list of backups, click the backup to restore, and then click OK
to start the restore.
5. Click OK to confirm that the restore completed successfully.
To delete and re-create the database users, follow these steps:1. Expand
your restored Project Server database.
2. Click Users, and then click the MSProjectServerUser user.
3. Press DELETE, and then click Yes to confirm the deletion.
4. Click MSProjectUser, and then press DELETE.
5. Click Yes to confirm the deletion.
6. Right-click Users, and then click New Database User.
7. Under Login name, click MSProjectServerUser, and then under Database role
membership select MSProjectServerRole.
8. Click OK.

The reason that you have to delete and re-add the users is SQL stores them
as unique ID's which can be different for each instance of SQL.

Here is the full link to backup and restore KB.
http://support.microsoft.com/kb/323330/en-us

Hope this helps,

 

[herngyih]

Thank you so much Ray!I succeeded!

Herngyih: try these steps:

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:1. Click Start, point to Programs, point to Microsoft SQL Server, and
then click Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand your
Microsoft Project Server database server, and then expand Databases.
3. Right-click the Microsoft Project Server database, point to All Tasks,
and then click Restore Database.
4. From the list of backups, click the backup to restore, and then click OK
to start the restore.
5. Click OK to confirm that the restore completed successfully.
To delete and re-create the database users, follow these steps:1. Expand
your restored Project Server database.
2. Click Users, and then click the MSProjectServerUser user.
3. Press DELETE, and then click Yes to confirm the deletion.
4. Click MSProjectUser, and then press DELETE.
5. Click Yes to confirm the deletion.
6. Right-click Users, and then click New Database User.
7. Under Login name, click MSProjectServerUser, and then under Database role
membership select MSProjectServerRole.
8. Click OK.

The reason that you have to delete and re-add the users is SQL stores them
as unique ID's which can be different for each instance of SQL.

Here is the full link to backup and restore KB.
http://support.microsoft.com/kb/323330/en-us

Hope this helps,
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts

 

[Darbha]

STAGE 1:
Original Configuration
SQL (Mixed Mode Authentication)
WSS (Default settings like app pools)
Project Server 2003.
No Service Packs
-----------------------------------
STAGE 2:
Backup Databases
STS_SERVERNAME_1
ProjectServer
Did not take backup for WSSdb(Config db)
-----------------------------------------
STAGE 3:
Uninstalled Project Server 2003
Uninstalled WSS
Deleted Databases from SQL 2000
Restarted SYSTEM
-----------------------------------------
STAGE 4:
Restored Databases with SAME NAMES.
(STS_SERVERNAME_1, ProjectServer)
IN ProjectServer db - deleted both
MSPROJECTSERVERUSER and MSPROJECTUSER and created the same
w.r.t KB article: 323330

Installed WSS following by accepting all
default settings and then connected to
restored db and delted default db.
While Installing Project Server

Screen : Chose Connect to another existing database and enter the server
name and database name
Screen : Checked Connect To Main Project Server 2003 Database
Screen : Enter Database Account Information
here i am providing MSPROJECTSERVERUSER and MSPROJECTUSER

When i click on NEXT Button, I am getting the following error
"The Specified MSProjectServerRole account is not in the MSProjectServerRole
role"

ARE THE ABOVE STAGES CORRECT.
PLEASE HELP ME TO SOLVE THIS PROBLEM.
I am having this problem since a week.

During Recovery Do i need to install WSS and PS2003
normally and then restore (WSS & PS2003) or Before

Any Ideas! Please Help
Darbha