I'm sure that if I were to search enough I would easily find the answers I'm looking for...but... I'm a creature of habit and like to get the fresh answers out of your wizards. Here's the deal... we recently go hit with the dreaded ransomware virus which took down a very critical server running SQL. We are a 911 dispatch center and in the panic we probably didn't do this "best practice". The a$$hats before me set up the Barracuda Backup 890 and I must say, it appears they did an awful job. So, here's my questions, and keep in mind this is a VMware environement...
1. What is better, adding each host as a source or using vCenter as the source?
2. We have Exchange, DCs, and other SQL servers running on these hosts. Should I back them up at the VM level AND create a seperate schedule and back them up with using the Agent? I want to be able to fire these suckers back up promptly, but also want granular recovery options. Yes - it will take more space.
3. What do you recommend for Bare Metal Recovery of a physical server that is running SQL? How should we back it up and what should we consider?
Please feel free to add anything I might not be thinking of and tell me how you all are doing things and any successes or hardships you've encountered. We were NOT able to recovery our SQL server because we just hit restore instead of attempting the SQL databases individually... it hoses the master databases... it sucked...still does.