Effect of service on log; stopping service
http://sqlblog.com/blogs/aaron_bertrand ... ssion.aspx
There were two issues I came across that I hope have very easy answers:
(1) the effect on the .ldfx file was substantial ... almost 10X the log compared to native or no compression, with an identical workload on identical hardware with same isolation level, same recovery model, etc.
(2) the effect on the database when the HyperBac service stops seems disastrous to me. I stopped the service and while my database is still there I cannot access it and don't know how to recover. Of course we should always be prepared for a disaster but if it's not known how critical the service is to the usage of the database we can see some real problems.
Again, hopefully these issues are covered somewhere and there's a simple answer, but they certainly gave me pause ... more for (2) than (1) obviously.