Open Forum

Back to discussions
Expand all | Collapse all

Offsite NAV backup

  • 1.  Offsite NAV backup

    Posted Dec 30, 2019 12:40 PM
    We are wondering what people might currently be using for an Offsite NAV backup service. This would be for an end of the day either manual or auto backup to the cloud.
    I know there are a lot of cloud storage solutions, but curious if anyone has a specific recommendation and why.
    Thanks, Curt

    ------------------------------
    Curt
    Para Gear
    Skokie IL
    ------------------------------
    Digital Acceleration Binge Day. January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 2.  RE: Offsite NAV backup

    TOP CONTRIBUTOR
    Posted Dec 31, 2019 09:54 AM
    Edited by Greg Enns Dec 31, 2019 09:56 AM
    We use a method that removes the need for SQL to Cloud backups--relying instead on our network server & file backups.
    We use SQL's built-in tools to take SQL backups hourly and at the end of the day. We use a PS script to move those backup files to a separate server. All our servers are backed up to the cloud nightly. We also have a routine to delete backups after a day or two since the cloud is storing nightly snapshots of the server.
    One thing to be careful of is that the server snapshot doesn't interrupt your SQL backup chain. (We use Datto which does interrupt the chain because of the way it takes the server snapshot. To compensate, I do a full backup every night AFTER Datto takes the snapshot.)

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Kaukauna WI
    ------------------------------

    Original Message
    Digital Acceleration Binge Day. January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 3.  RE: Offsite NAV backup

    TOP CONTRIBUTOR
    Posted Dec 31, 2019 12:40 PM

    I keep it simple for NAV as well.

    1. SQL Server Agent
    2. Create a Job
    3. Each job is for each day to backup the NAV database to a designated folder. Example 7pm, Repeats each week, overwrites file.
    4. Alert if fail email or event viewer log,

    https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job?view=sql-server-ver15
    or
    https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-transact-sql-job-step?view=sql-server-ver15
    or use the wizard

    Then send the file:
    FTP auto app
    Tape backup
    File/Copy to Memory stick or whatever device.

    Good luck.



    ------------------------------
    Geovanny Fuentes
    San Diego CA
    ------------------------------

    Original Message
    Digital Acceleration Binge Day. January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 4.  RE: Offsite NAV backup

    SILVER CONTRIBUTOR
    Posted Dec 31, 2019 02:05 PM
    You might consider setting up an Azure account (if you don't already have one) and then you can backup your on-premises SQL database to Azure blob storage.
    https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-use-storage-sql-server-backup-restore

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------

    Original Message
    Digital Acceleration Binge Day. January 28th 2021 | 11:00 AM - 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role