Standalone DB backup solution question

Evening

Just thought I'd better check - fairly new to P6 with a basic setup so I've simply enabled Windows' File History to backup the PPMDBSQLite.db to an external HDD on an hourly basis, thinking if there were any irretrievable mistakes, I could then use File History to restore the correct version and open P6 to find it recovered. 

If this works I'm happy to keep it like this, but if this isn't likely to work as a backup/recovery solution I'd need to know now.

Thanks for your help.

C
Craig Graham 👤 Member for 8 years 3 months

Thanks. That is certainly true. I suppose I just wanted to know if I'd overlooked something obvious (eg. "that clearly won't work because the .sqdb file is only one part, and there are many other files in memory that recording an instance would need" etc) and at least without those comments I can proceed to the testing knowing at least there's a possibility.  

D
David Kelly 👤 Member for 21 years 7 months

DAvid's Big Book of data processing says only one thing on page one:

 

IT IS NOT A BACKUP UNTIL YOU HAVE TESTED THE RESTORE

 

So, your solution is ok, BUT until you have moved the file to another empty P6 installation, and been able to open your projects, it does not count as a backup......

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts