I'm charged with looking after several SQL Server instances, most of which use SQL Server mirroring to replicate data for DR purposes.
I automatically script logins, roles & jobs to the mirror, in the event of a failover we literally need to run a script to bring the mirrors online, apply the logins, apply the rolls and jobs and away they go (give or take a few mismatched SIDs & the usual niggles).
Now, I have documented this failover process in case I am not on site in the event of a failure; however, management deems the process to be too complicated and keeps trying to push 3rd party replication products such as DoubleTake that could do instance level replication.
(Company did not want to use clustering for instance level as the shared storage would be a single point of failure – they were not willing to buy multiple replicating SANs.)
We have databases ranging from a few meg to 200GB+.
Is DoubleTake really practical for DR in this manner? Can I trust that the data will be bang up to date between the primary and secondary? (We operate high safety mode mirroring for this very reason.)
I've read lots of opinions on forums, but always either biased or unconfirmed; I'm after some first-hand experience with these products.