x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 1 subscriber
  • Views 172 views
  • Users 0 members are here
Browse Forums
Announcements
32
topics
2
replies
General Discussion
851
topics
2k
replies
Patrick Purcell

Working with Database Versions - BDB vs BBK

SOLVED
Posted By

What are the differences between backing up a database using the Backup Utility that creates a .bbk file and saving a copy of the .bdb file?

The use case in this scenario is we would want to create a version of the database after any large action has been performed (importing a large number of assets, large number of disposals, etc.) that could be reverted back to in case there was an error that occurred during that action.

I have worked with teams who create the .bbk backup of all companies within the database, save that backup, and restore those companies if there was ever a need to revert back to the older version. I have also heard from teams who create a copy of the original .bdb file, and simply connect to the older version if they need to revert back to the older version.

I wanted to know if there are any reasons why one should be favored over the other so that we can recommend a best practice.

Thanks,

Pat

  • 0
    SUGGESTED

    Hello Pat,

    In the case of reverting to an older version of a company in a database with multiple companies, I would recommend the .BBK file since the Company Restore process does allow the selection of the specific company to be restored. If there was any other work done in any of the other companies, reverting to an older copy of the database file will revert all the companies, not just a selected company.

    That being said, it is not uncommon for people to keep prior year copies of databases around for reference. For example, if you need to re-run year end reports.

    The only issue with restoring an older database would be if you are using the PDF attachment function. Adding an older copy of a database will not bring any of the PDF attachments along.

    I think that covers everything.

    ~Delray

  • 0

    Thanks, Delray.  And one follow up question, when backing up the companies within the database, do the customized reports get updated as well?  

    For example, if I had a customized report in a company, and after importing and depreciating assets, I made some adjustments to that report (reduce the spacing on a column, remove some fields, etc.) and then backed up that company.  Would the changes to that report be included in the backup file or would it only include the changes to the assets?

    Pat

  • 0
    verified answer

    The short answer is: Yes, Customized standard reports travel in the BBK file. 

    ~Delray

*Community Hub is the new name for Sage City