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

Author: Khuong Do

Khuong Do is a Project Planner in Civil, Transportation and Oil & Gas Industry. He has worked as a Primavera Consultant Specialist since 2006 . He holds a Civil Engineering degree and a Bachelor of Information Management System. Now he is working in Petronas RAPID project, one of the biggest Refinery and Petrochemical complex, in Pengerang – Malaysia.

1 thought on “How to backup and restore Primavera P6 SQL database”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s