Database-Mirroring

Tag: database-mirroring

High Availability Options for SQL Server 2008 in an Azure VM: A #sqlhelp Story

High Availability Options for SQL Server 2008 in an Azure VM: A #sqlhelp Story

I asked a question on Twitter yesterday: “If running SQL Server 2008 in an Azure VM (no SQL upgrade possible, extended support in place), is the best option for high availability Database Mirroring? Or something else I am not thinking of? #sqlhelp”

Continue reading

Database Mirroring Counters Missing from Perfmon?

Database Mirroring Counters Missing from Perfmon?

Collecting perfmon counters from SQL Server databases where you are using database mirroring is a little tricky

The counters won’t behave “normally” until after you set up mirroring for a database.

Continue reading

Useful Whitepapers for Planning SQL Server Migrations

Useful Whitepapers for Planning SQL Server Migrations

Planning to move to new hardware for your SQL Server? Techniques like log shipping and database mirroring can be incredibly useful to make the change fast and painless– but you’ve got to pick the right techniques for your environment ahead of time, and know how to do a few things that aren’t in the GUI.

Here are some of my favorite whitepapers and resources to get you going.

Continue reading

3 Ways Availability Groups Beat Database Mirroring

3 Ways Availability Groups Beat Database Mirroring

SQL Server Availability Groups are growing up. SQL Server 2016 adds more features and improvements, and these include options to run SQL Server in different domains, or withoutΒ a domain.

Continue reading