Please find the Presentation Slide Deck here on SkyDrive.
Contenu - Contents
Introduction to-à Microsoft SQL Server
Mirroring – Haut disponibilité avec des bases de données en mirroir. An updated version of this presentation will be given (mais en bilingue) based on several Blog posts, including: http://dbhive.blogspot.ca/2010/10/vermont-sql-server-user-group.html
- Connection Strings: http://dbhive.blogspot.ca/2010/10/connection-strings-database-mirroring.html
- Deep Dive (for those who are not satisfied with an intro, and need to use certificates, and complete code version of a mirror setup - mise en place d'un mirror par script, et sans domaine) : http://dbhive.blogspot.ca/2010/12/notes-from-mirroring-deep-dive-session.html
Note that if you want to group Mirrored databases, to mimmick Availability Groups in SQL 2012, you simply have to create a SQL Agent Job with a step that has the ALTER Database DBName Set Partner Failover; for each database you want in the group.
- Connection Strings: http://dbhive.blogspot.ca/2010/10/connection-strings-database-mirroring.html
- Deep Dive (for those who are not satisfied with an intro, and need to use certificates, and complete code version of a mirror setup - mise en place d'un mirror par script, et sans domaine) : http://dbhive.blogspot.ca/2010/12/notes-from-mirroring-deep-dive-session.html
Note that if you want to group Mirrored databases, to mimmick Availability Groups in SQL 2012, you simply have to create a SQL Agent Job with a step that has the ALTER Database DBName Set Partner Failover; for each database you want in the group.