Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6500 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:What to Back Up

So ,what to back up in the first place. Use the SQL Server Maintenance Plan set up wizard, and finish by setting up a job schedule to run the back ups. All your individual company databases must be included for a start. But don’t forget the Dynamics Database. Important constantly changing data is stored here, including multicurrency exchange rates, user security etc.  Your live databases should be backed up once every 24 hours using full recovery mode. Transaction log back ups can be very useful and you should look at performing these every so many hours during your working day. Without these, you are faced with losing a days data if you need to revert to last nigt’s backup. Your choice, depending on how critical GP is in your business, and whether you can identify what to re-input, and afford to re-input it! Keep your backups seperate – ie don’t apend the media…the files get very large, very quickly.

You will also want to back up your forms and reports dictionaries. Depending on your set file approach, this can be as easy as backing up a single shared folder on your server. If you are unsure what dictionaries you should be concerned about, open your Dynamics.set file and make sure every dictionary mentioned is being backed up. And don’t forget to include at least one application folder. If GP is installed on your server, then this is the one to take. At some stage you might have to re-install Dynamics…and having a back up of your application folder means you have a record to work from to retrieve add ins, VBA files and anything stored in the Data folder.

Ideally, each user should be backing up their application folder and any locally stored dictionaries.

On the MSSQL side, back up your user data. Worst case scenario, you will have to re-install SQL.

Back up to disk, (Disks or Tape?…no brainer…disks are now cheap, and you can get at your data faster and easier, and you don’t need tape backup software to add into the mix) and archive your backups off your server on a 5 day cycle. This keeps the most relevant backups easily available, and by transferring older ones off the server, keeps space requirement down. Don’t underestimate the joys of having a back up from before last years end – suddenly 12 months later, you discover that you need to run a report on data that was archived /removed by a year end process. In fact buy a few disks and rotate them in and out of your building so you have secure data off site should a ‘real’ disaster occur.

Category:SUPPORT (TECHNICAL): Backups
Link Owner:
Date Added:June 17, 2010 02:06:52 AM
Number Hits:1
RatingsAverage rating: (0 votes)

No Reviews Yet.