posted on Thursday, September 02, 2004 6:40 AM
by
RickH
DB Mirroring - User Group Meeting Feedback
I conducted a meting last night on the topic of DB Mirroring. The basics were explored as well as when / how to use it. After the meeting, I got some feedback about the features. Everyone seemed to be really excited about Mirroring and the Snapshots for Reporting purposes. The item they didn't like was the not being able to more than one system. Currently, a DB Mirroring session may be setup for either High Availability or for Disaster Recovery. Each has some different settings. The IDEAL would be to have two mirrors - one that could serve in the HA role and another serving in the DR role. There are other teachnologies/features that can help out with the DR role like replication and log shipping, but DB MIrroring is really all about uptime and is a much cheaper alternative to Clustering for most cases.
We had some good questions too. After I research the answers, I'll report back in another blog.