Will Netgear ReadyNas snapshots corrupt my Access 2010 database backend? RRS feed

  • Question

  • I have always understood that backing up a backend that's open/has a lock file is unsafe and can cause corruption.  I am backing up my backend at night to a Netgear ReadyNAS storage device once a day (when no one is using it). This ReadyNAS can take hourly snapshots of my backend which would be helpful in restoring my database in case of a mid-day corruption.  

    My questions are:
    Is it safe to do this?  
    Will taking hourly snapshots cause corruption in my backend if I don't use the snapshots?
    If I do use a snapshot, should I take some extra precautions like re-creating my database by importing all objects into a new database backend file?  


    Wednesday, February 8, 2017 9:23 PM

All replies

  • Hi SammieKay,

    Netgear ReadyNAS is just a storage device.

    below is the standard way to backup backend database.

    Backup a back-end database

    Notify users before you start the backup process because running the backup process requires exclusive access to the database file, and users may be unable to use the back-end database while the backup process is running.

    1. To open only the back-end database, start Access but do not open a database.

    2. Click Open, and then select the back-end database file that you want to backup.

    3. Click the arrow next to Open, and then click Open Exclusive.

      Option for Exclusively opening a specific database        

    4. Click the File tab.

    5. Click Save & Publish.    

    6. In the Save Database As area, under Advanced click Back Up Database.

    7. In the Save Database As dialog box, in the File Name box, review the name for your database backup.       

    Review the default name for your database backup. You can change the name if you want, but be aware that the default name captures both the name of the original database file and the date that you make the backup.


    Protect your data with backup and restore processes



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 9, 2017 3:02 AM