How to backup and restore Primavera P6 SQL database

How to Backup:

Go to Start -> SQL Server Management Studio

1

Enter Login information. The default username is “sa” and password is “Prima123Vera”

2

Select the database, right-click, go to Task -> Back Up

3

Click on “Add” button

4

Select the backup file destination

5

Enter backup file name

6

Click OK to start the backup

7

Then we’ve got the backup file in our hard-drive

8

How to restore database:

Right click on Database and select Restore database

9

Select database to overwrite or enter a new name to create a new database from the backup file.

10

Select “From device” and choose backup file

11

12

Change Files of type to “All files” then you can see your backup file. Select the backup file

13

Check on “Restore”

14

Go to “Option”. Check on “Overwrite the existing database”

15

Click OK. And database will be restored.

 

 

Advertisements

2 thoughts on “How to backup and restore Primavera P6 SQL database

Add yours

  1. I cannot open primavera as it is showing unable to connect to database (oracle 10g). I tried all options and my IT team is saying that it has to be re-installed. I have unsaved programs. Is there any option to backup the programs so that I can use the program when I reinstall the primavera p6.

    Thanks & Regards

    Like

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑