Still no answer on this? Well, it seems that HP strongly recommends we use their Sql Server backup system. They are saying that it is more efficient and dependable than Sql Server's normal dump system.
I am assuming you are talking about Omniback. We have no complaints here. The performance setting stuff up is painful, and security was a bit of a pain to configure, but once you have it in, it works pretty well.
It is not terribly intuitive in their interface, since everything is displaying according to the source of the data, rather than the destination, so I am usually holding my breath wondering if I am replacing the production database, but again, it does work, after you get used to the oddities.
Thanks, MCrowley. This knowledge is infinitely useful. As part of the development group, it is very easy to backup our databases with dumps and restore them to our dev machines when we need to. So I hesitate with this new HP method, which a different department would be in charge of.
So, if I need to replicate the production server onto 5 test boxes daily, it can be done?
and if I wanted to restore an instance of Sql server on to a test box from, let's say, 2 weeks ago, that would also be possible?