[dba-SQLServer] sql server 2005 database mirroring

Billy Pang tuxedo_man at hotmail.com
Thu Sep 15 13:38:43 CDT 2005


The article does not explicitly say that whether there is a bug problem or 
not with db mirroring, just lack of it in production use.  I hope that it 
gains popularity fast so that they can release db mirroring ahead of 
schedule they just set forth.  It is a pretty cost-effective way for 
disaster recovery compared to clustering.


>From: "Robert L. Stewart" <rl_stewart at highstream.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] sql server 2005 database mirroring
>Date: Thu, 15 Sep 2005 13:24:06 -0500
>
>Billy,
>
>Sounds like you will not need to worry about it:
>
>MCPmag.com: Database Mirroring Not Ready for Production When
>     SQL Server 2005 Ships
>When SQL Server 2005 is released to manufacturing in the next
>few months, Microsoft will take the exceptional step of
>designating one of its high-profile features as being intended
>for evaluation only.
>By Scott Bekker
>http://mcpmag.com/news/article.asp?editorialsid=846
>
>
>Robert
>
>
>At 12:00 PM 9/15/2005, you wrote:
> >Date: Thu, 15 Sep 2005 06:53:32 +0000
> >From: "Billy Pang" <tuxedo_man at hotmail.com>
> >Subject: Re: [dba-SQLServer] sql server 2005 database mirroring -
> >         howmany copies of sql server?
> >To: dba-sqlserver at databaseadvisors.com
> >Message-ID: <BAY102-F69929389101A8E6391725E59E0 at phx.gbl>
> >Content-Type: text/plain; format=flowed
> >
> >Hi Jim:
> >
> >Not sure if it is publishing or subscribing in this scenario. Are you
> >talking about (snapshot) replication?
> >
> >Database mirroring is new in sql server 2005, which is a bit different 
>than
> >replication.  in database mirroring, there is a principal database, which 
>is
> >what client accesses. if the principal database is disconnected, the 
>witness
> >tells the mirror server to become the principal server; the failover is
> >automatic and transparent to the client; replication is like database
> >mirroring because there are two copies of the db except that in db
> >mirroring, the client only sees one database. replication probably good 
>for
> >WANs; for db mirroring, it is preferred that all servers are on same 
>domain
> >over standard network infrastructre.
> >
> >Billy
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>





More information about the dba-SQLServer mailing list