Deploying to Mirrored SQL Database

Automated deployment for web applications and databases

Deploying to Mirrored SQL Database

Postby andrew.harrison » Tue May 27, 2014 10:41 am

For high availability, we are configuring our SQL 2012 databases to use Mirroring.

Does deployment manager support database mirroring? If so, how should we be configuring the servers in deployment manager?

For example is there a way of specifying the fail-over server in a single connection or do we just need to add both servers as separate targets?
Posts: 3
Joined: Wed Apr 30, 2014 9:28 am
Location: United Kingdom

Postby csmith » Fri Jun 06, 2014 1:00 pm


Deployment Manager does not currently have any special behaviour for mirrored databases.

If I understand mirroring correctly then one server instance serves the database to clients (the principal server) and the other instance acts as a hot or warm standby server (the mirror server). Therefore, I think you should still be able to set-up DM to deploy to the principle database server. The standby database server will update using the standard SQL Server synchronization (outside of DM).

So, you'd just need to create a database server target in DM for the principle db server.

If you do find you need to provide some special behaviour around deployments to your mirrored server - such as validating that the principle server is available - then we'd recommend writing a pre-deploy powershell to perform those actions, in combination with deployment variables. Examples of what Powershell can be used to do can be found on our powershell forum here.

I hope that helps.

Best regards,
Chris Smith
Project Manager
SQL Lighthouse
Posts: 120
Joined: Thu Jun 30, 2011 1:15 pm
Location: Cambridge

Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests