Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Double-Take vs. SQL Server Always On High Availability?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01635377
Message ID:
01635749
Vues:
60
>
>The IT guy thinks that if we store the MDF and LDFs on a central storage device (e.g. Nimble) and the SQL Server machine (VM) fails then all we have to do is fire up another VM with SQL Server installed on it and have it attach to the MDF and LDF files.
>
>I need to convince him that this really won't work because the MDF and LDFs were not properly detached. Sure, there are iffy workarounds, but I don't want to go there in a DR situation.
>
>I'd like to do this properly and I believe (not an expert) that we need to do this within the tools that MS SQL Server comes with. Again, my preference is to wait for SQL 2016 to come out...

Then you haven't eliminated a single point of failure, you've moved it to the central storage device.

With SQL mirroring + witness the entire server is redundant and the failover is automatic.
Brandon Harker
Sebae Data Solutions
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform