We use a large company as our service provider.
The tech people from that service company are pushing very hard to install something called the
Avamar SQL Agent which purportedly will be used to replace my old reliable full, differential, and transaction log backups. I am told that it constantly monitors the mdf, ndf, and ldf files for any changes and then writes the changed items (pages, ???) somewhere (???).
I am all for new technology once it is proven but I am skeptical of this approach that I will no longer need to take SQL Server native compressed backups (again full, diff, and tlog).
So far I have taken the stand that I am not going to bless this adventure unless and until they can prove to me through testing that it does not foul up my mdf, ndf, and ldf files and that a restore is still possible. Here again I don’t know what or who would do the restore per se… is it some derivation of SQL Server restore, some Avamar restore, some combination, etc.
Does anyone have any experience with this product?