Log Shipping Question

A user has SQL Server 2000 Personal Edition for production and wants
a
stand-by server to ensure availability of her data. I suggested that
we use a log shipping server so she has provided the Enterprise
Edition of SQL Server 2000. So correct me if the best approach here
is to:
1. Upgrade her personal edition version to Enterprise (Server 1)
2. Install Standard Edition to Server 2.
3. Instigate log shipping on Server 1 so that the data on Server 2
is
kept current.
or should she keep her Personal Edition on Server 1 and install the
Enterprise Edition to Server 2 with the Log Shipping features?
Thanks for any suggestions!
RBollingerAFAIK, the built-in log shipping support requires EE on both machines. I suggest you Google on
home-grown scripts for log shipping. They will work on any edition. After all, log shipping is
nothing more than backup and restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"robboll" <robboll@.hotmail.com> wrote in message
news:1174396428.546943.113190@.o5g2000hsb.googlegroups.com...
>A user has SQL Server 2000 Personal Edition for production and wants
> a
> stand-by server to ensure availability of her data. I suggested that
> we use a log shipping server so she has provided the Enterprise
> Edition of SQL Server 2000. So correct me if the best approach here
> is to:
> 1. Upgrade her personal edition version to Enterprise (Server 1)
> 2. Install Standard Edition to Server 2.
> 3. Instigate log shipping on Server 1 so that the data on Server 2
> is
> kept current.
> or should she keep her Personal Edition on Server 1 and install the
> Enterprise Edition to Server 2 with the Log Shipping features?
> Thanks for any suggestions!
>
> RBollinger
>