Cloudlucky's questions

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.

Source http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b7db6744-cd7b-42b5-a84e-5e511a5e8e59/mdf-ldf-files-last-modified-date-not-increasing-as-expected?forum=sqldisasterrecovery

Is there a way to backup the databases in the Backup Vault?

We have some issues with the transaction log files We have SQL Server 2008

Our situation:

• Every night, we have many jobs that runs on the server by SQL Agent
• Some jobs stop because the transaction log for database is full
• Everything is fine when we run failed jobs in morning

All databases recovery mode is Simple, except 2 databases (but we never get log full on them)
And the log file have the following option:

• Autogrowth
• 10 %
• Unrestricted (some have 2TB)

Disk space is not a problem, the hdd has never exceeded 60% Data and log have their own hdd

Do you have any idea how to correct the transaction log full problem?

UPDATE
Log File size
msdb ~150mb
master ~2mb
temp ~265mb
model ~2mb
The biggest log file is ~3GB, 3 have ~1GB, and the others are less than 1 GB
But we got log full on a 650mb and on a 27mb log file size