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.

ID:9881
Title:SQL Server Backups
URL:http://computerationdynamics.blogspot.com/2009/03/sql-server-backups.html
Description:Subject to the settings within SQL Enterprise Manager or SQL Server Management Studio, pre-posting backups are not needed with SQL 2000, 2005, or 2008.

Let’s assume a common situation with a company which operates Monday through Friday, 8 AM to 5 PM. From a simplified standpoint, not covering all options for setup of a SQL database, the properties of the DYNAMICS and company databases are set to a “Full” Recovery Model. This setting is coupled with a SQL Job that runs a SQL backup overnight AND runs SQL Transaction Log Backups every two hours throughout the work day.

If a problem with posting occurs at, say, 3:30 pm, this Recovery Model coupled with proper restore procedures allow a point-in-time restore to, say, 3:25 pm. No one is forced out of the system for extra backups throughout the day, but the ability to restore to any point in time is retained.

The ability to do a point-in-time restore directly conflicts with setting SQL databases to a “Simple” Recovery Model. The Simple Recovery Model does require pre-posting backups (or pre-anything-significant backups). These are disruptive in multi-user installations and subject to the whim of users who fail to backup at the most stressful, vulnerable times.

The use of backup and restore capabilities from inside Microsoft Dynamics GP should only be utilized with single-user installations set to the “Simple” Recovery Model. Even then, the backup and restore capabilities are limited in functionality when the SQL tempdb or user activity tables also need to be managed during a restore situation.

If your SQL Server is properly maintained, you should rarely need to interrupt daily processing with extra backups throughout the day.

There are many cautions, options, and settings with SQL that only a trained, experienced SQL Database Administrator (DBA) should deal with. Add to that, the SQL DBA should be familiar with the specific needs, requirements, and recommendations of Microsoft Dynamics GP databases and related directories and files. But properly setup and maintained, your SQL Server and Microsoft Dynamics GP should be extremely reliable, rarely needing work stoppages throughout the work day.
Category:SUPPORT (TECHNICAL): Backups
Link Owner:
Date Added:June 17, 2010 05:10:48 AM
Number Hits:4
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.