We use Barracuda Yosemite Server Backup against a couple large SQL Server installations, one of which is being manipulated 24/7. Never had an issue.
>DBA mentions that Red Gate executes on a daily basis at midnight for a full backup and partially during the day. When this is the case, I can no longer execute this:
>
>
>ALTER DATABASE MyDatabase ADD FILEGROUP BusinessTime
>
>
>This is very problematic. This is new as we did not have that structure before.
>
>Any Red Gate specialists how there who can confirm me what has to be done in Red Gate configuration to avoid locking on such items?
>
>Otherwise, please recommend other backup solutions that would not interfere with the good running of our database product.