Primavera
- Create database
- Restore PMDB Database with backup database
- Reset privuser and pubuser
After restoring Primavera database to new server, do this step :
EXEC sp_change_users_login ‘Update_One’, ‘privuser’, ‘privuser’
EXEC sp_change_users_login ‘Update_One’, ‘pubuser’, ‘pubuser’