Automatic Backup Procedures

navimbs
navimbs Member Posts: 137
edited 2008-08-06 in SQL General
Hi,
What are the various alternatives to take automatic backups of Navision SQL Server database?

Are there any documentation available?

Thanks,
Best regards,

Comments

  • garak
    garak Member Posts: 3,263
    Use SQL Backup from SQL Server.
    Read the manuals or online help
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]

    Best way is SQLServer backup (or some external application that makes a backup of the SQLserver DB).

    Another is the client-backup, but it is manual. You can use the Windows scheduler to make a backup.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • stryk
    stryk Member Posts: 645
    Hi!
    As "garak" said, you should create your backups from SQL Server site only, never use the NAV Client site feature except for very specific purposes.

    Check out the "Maintenance Plan" features from SQL Server, here you could setup everything fairly easy ...

    Regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Ola_Hallengren
    Ola_Hallengren Member Posts: 3
    edited 2012-04-01
    I have a set of maintenance stored procedures that you are welcome to use. The backup stored procedure supports full, differential and transaction log backups. It also does verify of the backups as well as deletion of old backup files.
    http://ola.hallengren.com/sql-server-backup.html

    Ola Hallengren
    http://ola.hallengren.com
  • hawwa
    hawwa Member Posts: 106
    SQL Server has the built-in capability to do scheduling backup.
    www.navision-girl.com

Categories