Re: mirrored sql servers
- From: "Greg D. Moore \(Strider\)" <mooregr_deleteth1s@xxxxxxxxxxx>
- Date: Sun, 06 Nov 2005 00:44:02 GMT
"Bernard Peek" <bap@xxxxxxxxxx> wrote in message
news:ahtXDqTk30aDFwG3@xxxxxxxxxxxxx
> In message <Xns97047DCD3077Yazorman@xxxxxxxxx>, Erland Sommarskog
> <esquel@xxxxxxxxxxxxx> writes
> >GB (v7v1k3@xxxxxxxxxxx) writes:
> >> The only purpose I have is to have a "backup" server to be ready
> >> to substitute main server at any time with recent data in it
> >> and "seamless" switching in production mode.
> >
> >OK. The I would suggest log shipping.
> >
> >However, you cannot really switch into real production mode with
> >Developer Edition, as you don't have a license for it. But it is
> >of course, perfectly OK to set up log shipping to learn how to
> >use it for a production scenario.
> >
> >Oh, I should add that once you come to production, you may only
> >have Standard or Workgroup Edition. Log Shipping is included in
> >Enterprise Edition only, so for these edition replication is about
> >the only option.
>
> If GB wants clustering and failover I think he will need the enterprise
> edition.
>
SQL Server 2005 will be released with DB mirroring, though in a "beta form".
He may want to look at this.
>
> --
> Bernard Peek
> London, UK. DBA, Manager, Trainer & Author.
>
.
- References:
- Re: mirrored sql servers
- From: Erland Sommarskog
- Re: mirrored sql servers
- From: Bernard Peek
- Re: mirrored sql servers
- Prev by Date: Re: DELETING 100 million from a table weekly SQl SERVER 2000
- Next by Date: Re: BlackBerry Enterprise Server - SQL problem
- Previous by thread: Re: mirrored sql servers
- Next by thread: Re: How can I tell if a sql server is MSDN or Standard or Enterprise version
- Index(es):
Relevant Pages
|
