This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
2011-09-02
3,660 reads
2011-08-31
2,002 reads
2011-08-18
2,110 reads
This great tutorial shows how to set up database mirroring across two instances in a virtual environment.
2014-01-31 (first published: 2011-04-12)
14,239 reads
2011-03-31
2,279 reads
There are times when you need to use different network ports to communicate between two servers running database mirroring. Learn how to change the default ports.
2011-03-14
10,295 reads
Learn how you can setup Database Mirroring using disparate file paths and drive letters.
2011-03-01
6,865 reads
Many people deploy performance monitoring solutions in a "one-size-fits-all" manner. That is, they tend to build a solution that can be easily deployed to multiple servers and capture basic information from each server. The trouble is that not every server is identical, not even within the same shop. For example, not every server may have database mirroring deployed, which means your performance monitoring solution may be missing some critical pieces of information with regards to monitoring database mirroring.
2011-02-03
4,101 reads
This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.
2013-07-29 (first published: 2011-02-01)
22,511 reads
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
6,049 reads
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
By DataOnWheels
Hey data friends! This one comes from my personal vault (aka backlog of drafts...
Comments posted to this topic are about the item Why you should avoid Implicit...
An error occurred during recovery, preventing the database 'XXXXX' (28:0) from restarting. Diagnose the...
Dear all, I have noticed that a "SELECT * ..." is about 10 time...
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers