I've found that Full Backups are taken through a snapshot of the VM itself within Azure and in return it breaks the log chain. That was what started...

Thanks Grant/Jeff, that is exactly my methodology as well that I just wanted to confirm.

What do you both do surrounding the VM backup, because if you have the...

Thanks Grant/Jeff, that is exactly my methodology as well that I just wanted to confirm.

What do you both do surrounding the VM backup, because if you have the...

Thanks Grant/Jeff, that is exactly my methodology as well that I just wanted to confirm.

What do you both do surrounding the VM backup, because if you have the "SQL Server...

• This reply was modified 5 years ago by  PhilipC.

Thanks for that, interesting comparison ! Only have 4 disks in a Raid 5 configuration and yes the IO is being totally maxed out. Server is over 5 years old...

No, I'm on SQL 2014.

Wow, that's some impressive storage you have there.  Do you mind sharing the results of this query? Below are my results. 

   SELECT @@SERVERNAME AS [Server Name] ,

Would love to, only recently started in the organisation and they have heaps of SQL 2000, SQL 2005 instances too.  Massive clean-up required but off-site backups are needed to be...

Thanks for the responses Zidar / Michael - appreciate it 🙂

Thanks Gail, that's a fair enough point. 
I'm interested in what checks others have put in place around situations like this though.

• Entity Framework  Steve? What are you planning...

Thanks for your thoughts guys, appreciate it.