Storm season is back, bringing with it the potential for significant weather events. If you have clients in areas prone to infrastructure disruption, visit the Disaster Recovery Resources guide for preparedness information. Datto recommends performing proactive disaster recovery testing to mitigate potential downtime. See our articles about the importance of disaster recovery testing and Preparing For A Cloud Virtualization Test: Policies, Procedures, And Partner Responsibilities to learn more. For live updates, follow @datto on Twitter.

How Do I Back Up Non-VSS Aware SQL Databases on Windows Machines?

Follow

Question

How do I back up non-VSS aware SQL databases?

Environment

  • Datto ALTO
  • Datto SIRIS
  • Windows OS (all versions)
  • Windows Server OS (all versions)

Answer

This information is specific to protected machines running Microsoft Windows and Microsoft Windows Server. Review this article for information about running quiescing scripts on Linux machines. 

SQL databases and VSS

To guarantee a healthy SQL database backup using the Datto backup solution, it must be application-aware. This means the SQL software needs an available VSS writer. The VSS writer tells the Datto device how to back up the application and its data.  

A VSS writer must be present for the Volume Shadow Copy Service to quiesce (freeze) the program in order to take an application-aware backup. Without a VSS Writer present, the Datto device will attempt to take a backup while transactions are actively being written. This could result in a corrupt or unhealthy backup of the database.

Datto agents do not offer the functionality to inject pre or post-backup scripts in order to pause database activity on Windows and Windows Server operating systems. Datto does not endorse third-party tools providing VSS-like functionality.

Backup method

Datto recommends creating a NAS share on the Datto device, then using the database software's native backup functionality to run a backup to that NAS share. This will ensure a healthy backup of the database is available in case of disaster.

Continuity

When logging into a non-VSS aware SQL server that is virtualized on the Datto device, you may find that the database is in a corrupt state. If so, you must perform a database restore using the backup file(s) that were created using the backup method above.

Additional Resources


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Head on over to our Community Forum!