SQL Server Database Mirror

SQL Server has many options to maintain a copy of your production database. It’s confusing to determine which method is best to use. Some of the possibilities: “log shipping”, “replication”, “mirroring”.

There’s an official best practices for the “mirroring” method at: Database Mirroring Best Practices and Performance Considerations. It looks like the mirroring feature was added in SQL Server 2005.

An article comparing “log shipping” to “replication” can be found at: http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/. This may have been written before the mirroring feature was available.

About notesbytom

Keeping technology notes on WordPress.com to free up my mind to solve new problems rather than figuring out the same ones repeatedly :-).
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s