I have SQL 2000 Enterprise edition on my production server, and SQL 2000
Standard on another server that will be used for my standby server. Can I
use Log Shipping in this case? I read I must have enterprise edition, but
do I need it on both servers?

Mike

Yes you can use log shipping.
Log shipping is a feature that is built in to the Enterprise Edition but it
is easy to set this up on your own.


314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515

323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135

325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220

821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786

321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247

329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133

--
Keith


"Mike" <mrfaber (AT) att (DOT) net> wrote

I know that log shipping is built in to Enterprise edition, and also that
you can configure it manully on standard edition, but can I use the builtin
log shipping on my production server(Enterprise Edition) to my standby
server(standard Edition) Or do they both have to be enterprise edition to
use the builtin feature.

Mike

"Keith Kratochvil" <sqlguy.back2u (AT) comcast (DOT) net> wrote

I don't know. I have never used the built in method -- I have always
created the log shipping routines myself. Call me old fashioned or call me
a control freak. Heck, I was doing this back in the SQL Server 6.5 days.
It is easy enough to set up the appropriate jobs so I always went that
route.

--
Keith


"Mike" <mrfaber (AT) att (DOT) net> wrote