|
|
Posted by Greg D. Moore \(Strider\) on 11/06/05 02:44
"Bernard Peek" <bap@shrdlu.com> wrote in message
news:ahtXDqTk30aDFwG3@shrdlu.com...
> In message <Xns97047DCD3077Yazorman@127.0.0.1>, Erland Sommarskog
> <esquel@sommarskog.se> writes
> >GB (v7v1k3@hotmail.com) 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.
>
Navigation:
[Reply to this message]
|