hi, do you suggest SqlServer ordinary backup methods or snapshot backups like veeam technologies?
what is difference?
It depends on your disaster recovery strategy , Usually I prefer to combine both:Create my bak files with sql server job and let the veeam to save these files.
I don't like snapshots on sql machines because they create io freeze , It could lead to problems especially on 24/7 systems with Availability groups .
Another option is to use veeam sql server backup module . it should be similar to ordinary backup methods but it will be managed by veeam
18 People are following this question.