I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs.
It works well to backup the websites but not the databases.
The modified dates change when SQL Server closes the files (SQL Server shut down or the database is detached), or when the file is grown (either automatically or manually). All other times, SQL Server essentially bypasses the file system when performing the writes, and so the modified dates aren't updated.
Is there a way to backup the databases in the Backup Vault?