none
Backing Up MS Access Databases RRS feed

  • Question

  • I know that DPM is SQL Server-aware and will backup these databases with no problem.  Is DPM also MS Access-aware?  My client has several multi-user Access databases stored on the network and I want to make sure they get backed up properly as I move them to DPM next month.

    Thanks,
    Joe

    Tuesday, October 2, 2012 2:28 PM

Answers

  • DPM uses the VSS subsystem to create snapshots of volumes in order to back up changed data.  As such, "open files" are not a problem at all.  They will be backed up by DPM.
    • Marked as answer by JWD2 Wednesday, October 3, 2012 1:32 PM
    Wednesday, October 3, 2012 1:13 PM

All replies

  • Hi

    I am sure you can backup the folder/s where the Access databases are located without a problem. 

    You can create a test protection group and run a backup and then see if you can restore the data.

    Kind Regards

    Wednesday, October 3, 2012 5:03 AM
  • Yes, backing up directories is a pretty basic assumption.  I'm asking if DPM will backup Access-specific files, especially multi-user files that may be left open overnight.
    Wednesday, October 3, 2012 12:12 PM
  • Hi Joe,

    DPM is non-Access aware so you would need to configure DPM to backup Access manually.


    My Blog | www.buchatech.com | www.systemcenterportal.com
    If you found this post helpful, please give it a "Helpful" vote. If it answered your question, remember to mark it as an "Answer". This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing!

    Wednesday, October 3, 2012 1:13 PM
    Moderator
  • DPM uses the VSS subsystem to create snapshots of volumes in order to back up changed data.  As such, "open files" are not a problem at all.  They will be backed up by DPM.
    • Marked as answer by JWD2 Wednesday, October 3, 2012 1:32 PM
    Wednesday, October 3, 2012 1:13 PM
  • Thanks all for your help on this.
    Wednesday, October 3, 2012 1:32 PM