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 >