How to backup and restore Primavera P6 SQL database

How to Backup:

Go to Start -> SQL Server Management Studio

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

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

Click on “Add” button

Select the backup file destination

Enter backup file name

Click OK to start the backup

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

How to restore database:

Right click on Database and select Restore database

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

Select “From device” and choose backup file

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

Check on “Restore”

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

Click OK. And database will be restored.