We maintain a warm standby by backing up transaction logs on the production
machine, then restoring them to the warm standby. Both machines are
currently running 2000 Standard. If we upgrade the production machine to
Enterprise (we want to be able to allocate more than 2 GB memory), can we
keep restoring logs to Standard (so that we can defer the cost of upgrading
it until a later time)?
TIA
Scott Nichol
All editions are binary on-disk compatible in SQL 2000. You can safely
restore a Standard Edition backup to an Enterprise Edition server. Your
"home-grown" log shipping will be just fine.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Scott Nichol" <reply_to_newsgroup@.scottnichol.com> wrote in message
news:uY7htr%23pFHA.3520@.tk2msftngp13.phx.gbl...
> We maintain a warm standby by backing up transaction logs on the
> production
> machine, then restoring them to the warm standby. Both machines are
> currently running 2000 Standard. If we upgrade the production machine to
> Enterprise (we want to be able to allocate more than 2 GB memory), can we
> keep restoring logs to Standard (so that we can defer the cost of
> upgrading
> it until a later time)?
> TIA
> --
> Scott Nichol
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment