Welcome to PCO Blogs

This is a place for Registered Users to share their technical view and opinions in form of blogs which they think might be useful to the greater PCO community. We invite prolific writers to share their insights and witticisms, but remind all contributors to be mindful of any copyright rules. ProjectControlsOnline will not be held responsible for any breach in rights and responsible users will be held accounted for the same.

Please note that you may NOT get badges, stars etc. by posting blogs here as they are pretty meaningless as they do NOT make you wealthier, fitter or more attractive to the opposite sex! The best you will get from contributing here is the satisfaction/self-respect from knowing you have helped others.  So, please continue to make positive contribution to this community portal and extend whatever help you can to your fellow colleagues.  Thanks!

 

Please read this help page before creating a blog

spacer
Latest blog entries

How to backup and restore Primavera P6 SQL database

Jun 21

Written by:
21/06/2016 17:46  RssIcon

How to backup and restore Primavera P6 SQL database

2

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

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.

Tags:
Categories:

Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 
spacer
Search Blogs
spacer